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

[taurus99]

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]

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

 

[mikebres]

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

Mike

 

[Gord Dibben]

ISERROR masks all errors which could lead to problems.

ISNA would be my choice.


Gord Dibben MS Excel MVP

 

[DDD]

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