Getting rid of error messages (ie Value)

Topic

New Reply

In the attached spreadsheet, I’m attempting to use the ISERROR formula to hide various error messages. Similar to =IF(ISERROR(#VALUE!),””,SUM(U115/R115)). Now when I copy/paste that, for some reason all cells are getting blanked out and I can’t figure it out. It might be the VLOOKUPS that are also in the workbook but I can’t be sure. Any assistance would be appreciated.

Thanks.

Reply | Quote

Replies

In the attached spreadsheet, I’m attempting to use the ISERROR formula to hide various error messages. Similar to =IF(ISERROR(#VALUE!),””,SUM(U115/R115)). Now when I copy/paste that, for some reason all cells are getting blanked out and I can’t figure it out. It might be the VLOOKUPS that are also in the workbook but I can’t be sure. Any assistance would be appreciated.

Thanks.

your supposed to put a “value” on the (#VALUE!)say something liked this
=IF(ISERROR(U115/R115),0,SUM(U115/R115))

Reply | Quote

Ah. Got it. Thank you.

Reply | Quote

Ah. Got it. Thank you.

np ENJOY

Reply | Quote