ssblue
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"
If D5 = "C" and AV5 is greater then 0 then AV5 - AW5 otherwise put "N/A"
If D5 does not = "C" put "N/A"
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.
ASKER
Sorry, please check the formula again.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Shums is on the right track, but:
=IF(AND(D5="C",AV5>0),(AV5 -AW5),"N/A ")
should work.
=IF(AND(D5="C",AV5>0),(AV5
should work.
OK... so I misread AND am slower than Shums!
LOL CompProbSolv
I was slow in her previous post :)