if then else conditions
=IF(E20,H2-E2,IF(AND(E2=0,F2=0),H2-D2),"")
What about
E2 = 0, F2 < 0
E2 <0?
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"wrosie" wrote in message
...
Someone helped me with this previously, and I accidentally cleared the
information (and the location of the post) from my computer. Ugh!
I'd appreciate help once again, and I promise not to lose it this time.
I need an If Then Else statement to combine the following:
If E 0, then H2-E2
If E2=0 and F2=0, then H2-D2
THANKS!
|