Building a red ledger
My apologies I am not even sure how to search of this, but I am trying to build a red ledger. Basically have it set up so there is a required sale every day and anything under, shows negative, anything over just shows zero.
So I have 1 column that has the number sold, next is sum of column1 - 5000, the last is column2/100. That last column I would like to add an if statement to zero out positive values.
Help Article Resources
Check out the Formula Handbook template!