Using Error Message as test Criteria

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Taru - 16 Jun 2006 16:36 GMT

If a formula returns a number or an error message how do I use the error
message in a logical test.

Signature

Taru

Reply to this Message

Tim M - 16 Jun 2006 17:16 GMT

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)

> If a formula returns a number or an error message how do I use the error
> message in a logical test.

Reply to this Message

dhoward - 16 Jun 2006 17:48 GMT

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"})?

>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.
[quoted text clipped - 4 lines]
>> If a formula returns a number or an error message how do I use the error
>> message in a logical test.

Reply to this Message