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

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

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%

"Peo Sjoblom" wrote:

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

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.


wrote:
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%

"Peo Sjoblom" wrote:

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

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

" wrote:

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