IF Statement

[Dave Coz]

Hi all:
I am trying to use an IF statement to do the following:
1. Check if the sum of D11+D17, if that equals 0.00, do nothing (leave the
cell blank).
2. If the sum is anything but 0.00, evaluate B3 and then based on the
contents in B3 change the sign (+, -) and perform some math.

Individually I can do all the pieces, I just can't get 1 and 2 to work in
unison.
I will keep plugging away at it, but if anyone can offer assistance, it will
be greatly appreciated.
Many thanks for you time and patience.
Cheers
Dave

 

[Daniel.C]

Hello.
Assuming D11 and D17 are numbers :
=IF(D11+D17<>0,(D11+D17)*-1,"")
HTH
Daniel

 

[Pete_UK]

Try something along these lines:

=IF(D11+D17=0,"",IF(B3>=0,action_if_positive,action_if_negative))

You didn't elaborate what you wanted to do if B3 is positive or
negative, but perhaps you can plug your actions in as appropriate.

Hope this helps.

Pete

 

[Dave Coz]

Helloo Daniel,
Thanks for the info. What I am trying to do is use the contents in B3 to
make the choise on whether or not I need to change the sign. All this hinges
on whether or not the sum of D11, D17 <>0. If it doesnt equal 0 then based
upon B3 I may need a positive or a negative result.
Perhaps it is not possible?
Thank you.
Dave

 

[Dave Coz]

THank you!

Try something along these lines:

=IF(D11+D17=0,"",IF(B3>=0,action_if_positive,action_if_negative))

You didn't elaborate what you wanted to do if B3 is positive or
negative, but perhaps you can plug your actions in as appropriate.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome.

Pete