Error

T

Tomek

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.
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top