Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What wrong with IF formula | Excel Discussion (Misc queries) | |||
Is anything wrong with this formula? | Excel Worksheet Functions | |||
Formula returning "A value used in the formula is of the wrong dat | Excel Worksheet Functions | |||
Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
What is wrong with formula? | Excel Worksheet Functions |