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.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Divide by Zero Error Message


How do I hide of the Divide by Zero Error Message?

Posted on May 19, 2023 12:56 PM

Reply
Question marked as Top-ranking reply

Posted on May 20, 2023 1:50 AM

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

2 replies

May 19, 2023 11:47 PM in response to krista195

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

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.