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)


" wrote in
message ...
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