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)

:laugh

DonaMil;699213 Wrote: 
> 
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)



___________________________

Is this what you need?

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


-- 
Dianne
------------------------------------------------------------------------
Dianne's Profile: http://www.thecodecage.com/forumz/member.php?u=1755
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=195614

http://www.thecodecage.com/forumz

Replace IFText with plain If...
-- 
HTH...

Jim Thomlinson


"DonaMil" wrote:

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

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.
-- 
Hope this helps.  
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"DonaMil" wrote:

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