Error
Is there any way to set a cell to 0 if any error(eg DIV/0 or VALUE
occurs -- Message posted from http://www.ExcelForum.com |
Error
It depends what You are doing.
You may use IF function, for instance. Assuming that You want to divide value in cell A2 by value in B2 You may write a following formula: =IF(B2=0,0,A2/B2) It will check if value in B2 equals 0 and if so return 0, if the opposite return result of A2/B2. "courtesio99" wrote in message ... Is there any way to set a cell to 0 if any error(eg DIV/0 or VALUE) occurs? --- Message posted from http://www.ExcelForum.com/ |
Error
Hi courtesio99!
Here's an example of the standard approach: =IF(ISERROR(A1/A2),"",A1/A2) But make sure that you are happy with the errors that you are hiding. -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "courtesio99" wrote in message ... Is there any way to set a cell to 0 if any error(eg DIV/0 or VALUE) occurs? --- Message posted from http://www.ExcelForum.com/ |
All times are GMT +1. The time now is 11:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com