Hello:

Recently, someone on this message board helped me out by telling me about
the "ISERROR" formula and using this formula to fix an If,Then statement that
was not returning an incorrect value.

What is "ISERROR" and does it allow for overriding situations where Excel is
not returning the correct value in an If,Then statement?

And, what does "UPPER" do?

Thanks!

childofthe1980s

This can all be found in Excel's HELP

--
Kind regards,

Niek Otten

"childothe1980s" wrote in message
...
Hello:

Recently, someone on this message board helped me out by telling me about
the "ISERROR" formula and using this formula to fix an If,Then statement
that
was not returning an incorrect value.

What is "ISERROR" and does it allow for overriding situations where Excel
is
not returning the correct value in an If,Then statement?

And, what does "UPPER" do?

Thanks!

childofthe1980s

If you had used Search instead of Find, you wouldn't need Upper
=IF(ISERROR(Search("CREDIT CARD",$E7,1)),"","VISA")

If you read the help on Search or Find, you would see they return an error
value if they don't find the search string.

--
Regards,
Tom Ogilvy


"childothe1980s" wrote in message
...
Hello:

Recently, someone on this message board helped me out by telling me about
the "ISERROR" formula and using this formula to fix an If,Then statement
that
was not returning an incorrect value.

What is "ISERROR" and does it allow for overriding situations where Excel
is
not returning the correct value in an If,Then statement?

And, what does "UPPER" do?

Thanks!

childofthe1980s