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

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

or

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

--

Dave Peterson

or

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

--

Dave Peterson

Check out the IS Functions in the help file. ISNA will work for your

situation, but ISERROR will be a more general solution.

Mike

situation, but ISERROR will be a more general solution.

Mike

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

ISNA would be my choice.

Gord Dibben MS Excel MVP

On Fri, 2 Jan 2009 16:37:01 -0800, mikebres

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

then put true if it is false then put ""

Not sure if it would work though

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.

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.

2. ifs and buts

4. New IFS interface (jfs.ifs, udf.ifs for example)

6. What does IFS="${IFS}[]()" mean?

7. Why there is a need of IFS and non-IFS LSP sockets?

8. differecnce between ${IFS} and "${IFS}"

9. IFs, ELSEs, END IFS -- proper construction

10. Editing and Moviing from 6 If's to 7 Ifs (Nested)

12. Small (JFS.IFS or HPFS.IFS AutoCheck) install bump, Solved!

13. nested ifs and end ifs and elses

14. HELP - If and but's formulas?

6 post • Page:**1** of **1**