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 :)