multiple functions in one formula

E

enorth

I want to state if column D is less than zero and if columb D _C is less than
0 then d-C x 25%....I have tried if stmt and if and I can't get it..help
 
P

Peo Sjoblom

Don't understand what "columb D _C" means? Do you mean D-C?

Also what if the condition is not TRUE?

=IF(AND(D2<0,D2-C2<0),(D2-C2)*25%,"Not TRUE")

--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(remove ^^ from email)
 
E

enorth

Yes, I did mean D-C and I'm not looking for the result "Not True" I want to
calculate the value of (d2-c2)*25% and show answer....maybe this is a better
way to write my question....If D2<0,0 and if D2-C2 is >0 then calculate
D2-C2*25%
 
S

sloth

What do you want the value to be if D2<0, but D2-C2 >=0?

It seems Peo's response may have already answered your question. "Not
True" is only displayed in cases where both tests are not true. You
can change "Not True" in the if statement to 0 or "", if you prefer.
 
E

enorth

IF D <0,0 AND IF D-7>0 THEN I want to do this calculation D-C*25% and I want
the answer to appear in another column
 
Top