Excel formula with two ifs

ssblue
ssblue used Ask the Experts™
on
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"
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
How can D5="C" (a string value) and be greater than 0 (a numeric value)?
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
=IF(AND(D5="C",D5>0),(AV5-AW5),"N/A")
Sorry...ignore my post.  I misread the request.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

ssblueCoordinator

Author

Commented:
Sorry, please check the formula again.
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
=IF(AND(D5="C",AV5>0),(AV5-AW5),"N/A")
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!
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
LOL CompProbSolv
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
I was slow in her previous post :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial