| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
using "if" but omitting the #n/a's
I am using a simple formula
=IF(AQ3<=10,TRUE,FALSE) except I want to add.... if #n/a then put TRUE how do I add that to my formula? Thanks in advance!!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using "if" but omitting the #n/a's
=if(isna(aq3),true,if(aq3<10,true,false))
or =if(isna(aq3),true,aq3<10) taurus99 wrote: I am using a simple formula =IF(AQ3<=10,TRUE,FALSE) except I want to add.... if #n/a then put TRUE how do I add that to my formula? Thanks in advance!!! -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using "if" but omitting the #n/a's
Check out the IS Functions in the help file. ISNA will work for your
situation, but ISERROR will be a more general solution. Mike "taurus99" wrote: I am using a simple formula =IF(AQ3<=10,TRUE,FALSE) except I want to add.... if #n/a then put TRUE how do I add that to my formula? Thanks in advance!!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using "if" but omitting the #n/a's
ISERROR masks all errors which could lead to problems.
ISNA would be my choice. Gord Dibben MS Excel MVP On Fri, 2 Jan 2009 16:37:01 -0800, mikebres wrote: Check out the IS Functions in the help file. ISNA will work for your situation, but ISERROR will be a more general solution. Mike "taurus99" wrote: I am using a simple formula =IF(AQ3<=10,TRUE,FALSE) except I want to add.... if #n/a then put TRUE how do I add that to my formula? Thanks in advance!!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using "if" but omitting the #n/a's
In you formula replace the word False with an if error formula, if its true
then put true if it is false then put "" Not sure if it would work though "taurus99" wrote: I am using a simple formula =IF(AQ3<=10,TRUE,FALSE) except I want to add.... if #n/a then put TRUE how do I add that to my formula? Thanks in advance!!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
using "if" but omitting the #n/a's
If you're not sure whether it would work, why not try it, DDD? [Microsoft
don't charge you extra to try a formula!] The answer is that if AQ3 is NA() you'll get an NA() result from the first formula, so you'd need to do the tests the other way round, testing for NA() first before the AQ3<=10 test. -- David Biddulph DDD wrote: In you formula replace the word False with an if error formula, if its true then put true if it is false then put "" Not sure if it would work though "taurus99" wrote: I am using a simple formula =IF(AQ3<=10,TRUE,FALSE) except I want to add.... if #n/a then put TRUE how do I add that to my formula? Thanks in advance!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) | |||
Linear Mode
