Link to home
Start Free TrialLog in
Avatar of ssblue
ssblueFlag for United States of America

asked on

Excel formula with two ifs

I need the following put into a formula.

If D5 = "C"   and AV5  is greater then 0   then AV5 - AW5  otherwise put "N/A"

If D5 does not = "C" put "N/A"
Avatar of CompProbSolv
CompProbSolv
Flag of United States of America image

How can D5="C" (a string value) and be greater than 0 (a numeric value)?
=IF(AND(D5="C",D5>0),(AV5-AW5),"N/A")
Sorry...ignore my post.  I misread the request.
Avatar of ssblue

ASKER

Sorry, please check the formula again.
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Shums is on the right track, but:
=IF(AND(D5="C",AV5>0),(AV5-AW5),"N/A")
should work.
OK... so I misread AND am slower than Shums!
LOL CompProbSolv
I was slow in her previous post :)