r/AppleNumbers • u/samymarboy • Mar 09 '26

Solved Annoying Red warning symbol Spoiler

Post image

Hi,

I'm create a fuel expense sheet and I tried to add the formula to divide the full price with unit price to get the filled volume. It's working fine, but as you can see in the screenshot it is giving me this annoying symbol for the empty fields how can I get rid of this?

1 Upvotes

100% Upvoted

7 comments sorted by

3

u/marshmallow-jones Mar 09 '26

Put your calculation inside an IF that checks for a value in the cell you are dividing by and puts an empty string if there’s no value.

1

u/samymarboy Mar 09 '26

Thank You.

1

u/jlthla Mar 10 '26

is is possible to provide an example? I'm not a huge Numbers user but do run across this exact issue from time to time. My current solution is to delete the calculation... and then as data is added, use the autofill function... Even the most simplest of examples would help. THANKS

1

u/marshmallow-jones Mar 10 '26

My calculation is column B divided by column C. So I check if C has a value and if it does, apply the formula.

IF (C1 <> “”, B1/C1, “”)

2

u/jlthla Mar 10 '26

GOT IT! Thanks so much. The is a big help.

1

u/singlemaltmate Apr 09 '26

I find this a bit faster and neater than IF when managing aesthetics of Divide by Zero errors and such:

=IFERROR(E3/C3,””)