Using Error Message as test Criteria

  • Thread starter Thread starter Taru
  • Start date Start date
T

Taru

If a formula returns a number or an error message how do I use the error
message in a logical test.
 
Here is a formula that with a Cell A2/B2. If there is an error (such as Div
0#) it inserts a blank, if there is no error it does shows the calculation.
does that help?

=IF(ISERR(A2/B2)=TRUE,"",A2/B2)
 
Wow, I was just wondering how to do this and here's this posting. I am
working with a large spreadsheet which is downloaded each month. I've pasted
my formula into an entire row and now want those cells with the error message
to be blank. How do incorporate this into my formula, =LOOKUP(AA23,{0.12,0.
13,0.14,0.15,0.16,0.17,0.18,0.19,0.2,0.21,0.22,0.23,0.24,0.25},{".08",".10",".
10",".10",".105",".11",".11",".13",".13",".13",".14",".14",".14"})?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR?? 0
Logical Test for blank and then for score 1
How can I test the text content of a cell 4
Count the times a value appears in a column based on another value 6
Testing cell value for greater than 0 1
subtotal with sumif nested 1
How to subtract a number from a Mergefield? 0
TRUE/FALSE function in IF statement 2

Back
Top