Divide by Zero Error Message
How do I hide of the Divide by Zero Error Message?
You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
How do I hide of the Divide by Zero Error Message?
You can also test specifically for 0 in F12, like this:
=IF(F12=0,"",(D12+'Table 2-1-2-1-1-1'::E8)/F12+'Table 2-1-2-1-1-1'::B$1+('Table 2-1-2-1-1-1'::B$1/F12))
If F12 is 0 this makes the cell appear blank. If F12 is not 0, your original formula applies.
SG
You can also test specifically for 0 in F12, like this:
=IF(F12=0,"",(D12+'Table 2-1-2-1-1-1'::E8)/F12+'Table 2-1-2-1-1-1'::B$1+('Table 2-1-2-1-1-1'::B$1/F12))
If F12 is 0 this makes the cell appear blank. If F12 is not 0, your original formula applies.
SG
One way would be to wrap the formula with an IFERROR function that returns a different message, a blank, or a number if the formula returns an error.
IFERROR(formula,if-error)
Here's an example:
The formula shown below the table is entered as shown in cell D2, then filled down to cell D6.
The pair of quotation marks at the end of the formula tell Numbers to return a null string if the division in the first argument returns an error. If there is no error (as seen in rows 3 to 6) the formula returns the result of the division.
Regards,
Barry
PS: ANY error, not just a 'division by zero' error will be detected by the formula, which will then return a null string.
Regards,
Barry
Divide by Zero Error Message