using "if" but omitting the #n/a's

using "if" but omitting the #n/a's

Post by dGF1cnVzOT » Sun, 04 Jan 2009 09:24:04


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

using "if" but omitting the #n/a's

Post by Dave Peter » Sun, 04 Jan 2009 09:34:26

=if(isna(aq3),true,if(aq3<10,true,false))
or
=if(isna(aq3),true,aq3<10)




--

Dave Peterson

 
 
 

using "if" but omitting the #n/a's

Post by bWlrZWJyZX » Sun, 04 Jan 2009 09:37:01

Check out the IS Functions in the help file. ISNA will work for your
situation, but ISERROR will be a more general solution.

Mike
 
 
 

using "if" but omitting the #n/a's

Post by Gord Dibbe » Sun, 04 Jan 2009 10:07:21

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
 
 
 

using "if" but omitting the #n/a's

Post by RERE » Sun, 04 Jan 2009 10:36:01

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
 
 
 

using "if" but omitting the #n/a's

Post by David Bidd » Sun, 04 Jan 2009 18:04:31

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.