What is wrong with this formula? Please help!

D

DonaMil

I am in Excel 2003. The error comes back with a "#value" entry. The
original formula was okay until I wanted to add the condition that if there
was text reading "Full Duty" in R8 I wanted the cell to show "NA" instead of
the formula result. I've tried several different ways but always come up
with either an error message telling me my formula is wrong or it goes
through and I get an "#value"entry

=IF(ISERROR((YEAR(O8)-YEAR(K8))*12+MONTH(O8)-MONTH(K8))/12,"NA",((YEAR(O8)-YEAR(K8))*12+MONTH(O8)-MONTH(K8))/12),IFText(R8="Full
Duty","NA",((YEAR(O8)-YEAR(K8))*12+MONTH(O8)-MONTH(K8))/12)
 
G

Gary Brown

Is this what you're looking for?
=IF(ISERROR((YEAR(O8)-YEAR(K8))*12+MONTH(O8)-MONTH(K8)/12),"NA",IF(R8="Full
Duty","NA",((YEAR(O8)-YEAR(K8))*12+MONTH(O8)-MONTH(K8))/12))

FYI, there is a IsText( ) function but no IfText( ) function.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with Formula... 1
What is wrong with this COUNTIF formula? 10
VLookUP formula help! 5
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
Nested IF limit or Open parentheses limit 5
I need help with this program written in Visual Basic for Excel 2007. 4
help to in setting up a proper Vlookup table and formula 4
value time formula help please 4

Top