I want to return a negative number as this sheet will be used for our accounts payable team.
I'm using a simple Sum formula. I want to display this as a negative. conditional formatting to change the color will not work. It needs to either be -$192,000 or (192,000)
=SUM([2021 Total]1:[2021 Total]46) = 192,000
I've tried sumIF with no luck too.
it's really just adding up all the values but I need the total to be negative. Please help.
Best Answer
-
Try subtracting it from zero
=0 - SUM([2021 Total]1:[2021 Total]46)
Answers
-
Try subtracting it from zero
=0 - SUM([2021 Total]1:[2021 Total]46)
-
@Paul Newcome Yes!! I knew there was something simple I was missing. Think my brain is tired b/c I tried some combo of that but had the 0 in incorrect place. Anyway, this worked perfectly, thanks for quick response!😁
-
No worries. Sometimes it is good to take a step back or ask for another set of eyes. After a while you get so used to the complicated bits that the easy bits become impossible. Haha
Happy to help. 👍️
Help Article Resources
Categories
Check out the Formula Handbook template!
