ERROR.TYPE

Posted by B. Smith on May 03, 2001 1:10 PM

Please help:

I am trying to use the IF(ERROR.TYPE) command to overcome several error messages which are unavoidable due to the nature of my sheet.

My problem is that I can't seem to get the
IF(ERROR.TYPE) to execute the else portion of the IF.

Here is an example of what I mean:
=IF(ERROR.TYPE(24-(I5+J5+G5))=3,"",24-(I5+J5+G5))

This will return a blank when the error type is #Value, but when test actually should return a number; for some reason it doesn't advance to the
24-(I5+J5+G5) as it should.

Any ideas on what I am doing wrong?

Thanks.

Posted by Mark W. on May 03, 2001 1:21 PM

What are the contents of I5, J5 and G5?

Posted by B. Smith on May 04, 2001 8:37 AM

They are cells that can contain either a postive numerical value or a blank (generated using "")based on a specific condition. The error seems to be generated due to my using a calculation that can't handle the blanks.

Posted by Aladin Akyurek on May 04, 2001 9:15 AM

WOULDN'T THE FOLLOWING DO WHAT YOU WANT:

=IF(ISERROR((24-(I5+J5+G5)),"",(24-(I5+J5+G5))

JUST CURIOUS: WHAT IS THE FORMULA THAT CANNOT HANDLE BLANKS?

Posted by B.Smith on May 04, 2001 10:57 AM

Thanks for the help folks. I was fairly sure that there must have been some kind of function in there like that, but do you think I could find it? Heck no.

Thanks for the assist. This is going to help me out big time with several appearance based issues in my spreadsheet.

WOULDN'T THE FOLLOWING DO WHAT YOU WANT: