david remichi
asked on
Can anyone help me on what I think is a IF formula.
Hi
I guess you know im not too sure what im talking about about I think its a IF formula but have no idea.
I have data in cells D12/D13/D42/D45 and data in cells H25/H44 and N34.
If the value of data combined in D12/D13/D42/D45 is GREATER than value of data combined in H25/H44 and N34 then I need the difference shown in cell H50 but if it is the other way round as then I need the difference shown in D50.
Any Ideas?
I guess you know im not too sure what im talking about about I think its a IF formula but have no idea.
I have data in cells D12/D13/D42/D45 and data in cells H25/H44 and N34.
If the value of data combined in D12/D13/D42/D45 is GREATER than value of data combined in H25/H44 and N34 then I need the difference shown in cell H50 but if it is the other way round as then I need the difference shown in D50.
Any Ideas?
ASKER
Add them together.
Formula for cell H50:
Formula for cell D50:
If all your numbers are zero or larger, the value in cell D50 will be negative. Is that what you want to happen?
=IF(SUM(D12,D13,D42,D45)>SUM(H25,H44,N34),SUM(D12,D13,D42,D45)-SUM(H25,H44,N34),"")
Formula for cell D50:
=IF(SUM(D12,D13,D42,D45)<SUM(H25,H44,N34),SUM(D12,D13,D42,D45)-SUM(H25,H44,N34),"")
If all your numbers are zero or larger, the value in cell D50 will be negative. Is that what you want to happen?
ASKER
Just tried and Want D50 to be a positive figure please.
Formula for D50 then becomes:
=IF(SUM(D12,D13,D42,D45)<SUM(H25,H44,N34),SUM(H25,H44,N34)-SUM(D12,D13,D42,D45),"")
ASKER
Big thanks for tthat but now ive just realised I got hundreds of formulas to put in and looked at a different way of doing it.
If I have a POSITIVE figure in Cell Z10 I want that linked to cell D50 with the figure but if Z10 is a NEGATIVE figure I need it linking to cell H50 but need it showing in H50 as a POSITIVE.
Sorry to change my plan
If I have a POSITIVE figure in Cell Z10 I want that linked to cell D50 with the figure but if Z10 is a NEGATIVE figure I need it linking to cell H50 but need it showing in H50 as a POSITIVE.
Sorry to change my plan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are they division signs or do you mean to add them together?