ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   What is wrong with this formula? Please help! (https://www.excelbanter.com/excel-discussion-misc-queries/261509-what-wrong-formula-please-help.html)

DonaMil

What is wrong with this formula? Please help!
 
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)

Jim Thomlinson

What is wrong with this formula? Please help!
 
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)


Gary Brown[_6_]

What is wrong with this formula? Please help!
 
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)



All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com