SIGN UP

Zero Values In Mac Numbers 10.1

Avatar Image
camioneur | 16:14 Mon 21st Sep 2020 | Computers
5 Answers
I'd like to leave a blank cell rather than a zero in spreadsheets that contain a "SUM" formula
I know I can use conditional formatting to hide the zero but that's not what I need.
i.e. A6 = SUM A1:A5. Surely there's an easy formula to hide the zero in A6 if there are no entries in cells A1:A5

Answers

1 to 5 of 5rss feed

Best Answer

No best answer has yet been selected by camioneur. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
in A6 put =IF(SUM(A1:A5)=0," ",SUM(A1:A5))
Question Author
Thanks for that and that's exactly what I thought I should do but it doesn't work for me and I don't know why!
I've copied your formula exactly though in my case the cells are H4:H8 with the results in H9 and this is it in text format that I entered in H9 IF(SUM(H4:H8)=0,"",SUM(H4:H8)) but I still get the red triangle. Any ideas what I'm doing wrong?
= sign before the IF, also right click and make sure the format is "general", I tried it here, should work.
Question Author
ThanksTora, it does work. I created another spreadsheet and tried it again and it worked immediately. The problem appears to be in the spreadsheet as it is auto-populated from another sheet and that seems to be the cause. Thanks very much for your help
anytime!

1 to 5 of 5rss feed

Do you know the answer?

Zero Values In Mac Numbers 10.1

Answer Question >>

Related Questions