IF Statement

  • Thread starter Thread starter Dave Coz
  • Start date Start date
D

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
 
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
 
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
 
THank you!

Pete_UK said:
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
 
Back
Top