ISERROR function to remove #VALUE

**singerbatfink** · 11-26-2010, 06:08 AM

Hi,

I cant get the ISERROR function in this if statement to remove the #VALUE, could someone tell me what Ive done wrong here?

Please Login or Register  to view this content.

Thanks in advance.

B

**Richard Buttrey** · 11-26-2010, 06:16 AM

Hi,

Difficult to be sure without seeing the formula in context, i.e. in the workbook, but try:

Please Login or Register  to view this content.

HTH

**singerbatfink** · 11-26-2010, 06:31 AM

Hi Richard,

Thanks for your prompt response. I did try your suggestion but it still returned the error.

Ive attached a scenario so you can have a better look at it.

Regards

B

**arthurbr** · 11-26-2010, 06:53 AM

Is the attached what you need?

**KiPA** · 11-26-2010, 06:54 AM

Why is there that C3 in value_if_true merge? Because with this logic it would be empty (because there would be nothing in C3) so that it would be unnecessary in the first place.

Edit: never mind

**singerbatfink** · 11-26-2010, 07:15 AM

Thanks arthurbr,

Thats got rid of the #VALUE. How do I now make the cell look blank if there is no data in the table?

B

**Richard Buttrey** · 11-26-2010, 07:15 AM

Hi,

Why not just

Please Login or Register  to view this content.

Rgds

**singerbatfink** · 11-26-2010, 08:22 AM

Thanks for the help.. Great stuff..

ISERROR function to remove #VALUE

LinkBack

Thread Tools

Rate This Thread

Display

ISERROR function to remove #VALUE

Re: ISERROR function to remove #VALUE

Re: ISERROR function to remove #VALUE

Re: ISERROR function to remove #VALUE

Re: ISERROR function to remove #VALUE

Re: ISERROR function to remove #VALUE

Re: ISERROR function to remove #VALUE

Re: ISERROR function to remove #VALUE

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions