Thread: using "if" but omitting the #n/a's
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
taurus99 taurus99 is offline
external usenet poster
  
Posts: 16
Default 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!!!
Reply With QuoteReply With Quote