•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Zero balance formatting. How to make appear positive 0 when value = 0 and not negative 0?
I use excel for my checkbook. When the balance is $0.00 it is displaying in RED as ($0.00). How do I get it to display as $0.00 and not in RED. Searching didn't really help as it was making negative values positive. I just want to make $0.00 appear as normal positive number.
The formula I am using is "=SUM(C5:C500)"
If I use the formula "=LOOKUP(2,1/(C:C<>""),C:C)" then it does display correctly but that is just retrieving the last value. Not the sum of the column.
Many thanks for any assistance!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#natural language processing for spreadsheets
#AI formula generation techniques
#generative AI for data analysis
#Excel compatibility
#formula generator
#Excel alternatives
#rows.com
#row zero
#zero balance
#Excel
#$0.00
#formatting
#positive number
#formula
#checkbook
#SUM function
#display
#LOOKUP function
#negative