Forum Discussion
Solved
Help with IF function
I need help with the Owed by 11/23 column. I'm a scout leader and we have a spreadsheet to track popcorn sales, dues owed, etc. Scouts are requested to sell a certain amount of popcorn to cover t...
Would this work? If dues are less than 125, it uses the difference of that number instead of 125. The Max just makes it so if they owe a negative amount it rounds up to 0.
Thank you! That helped with all the lines except for this one:
76.00 72.00 4.00 53.00
It should show $4 in the column with the 53. Any thoughts? I can manually correct this (and a couple others) but curious what the correct fix would be?
76.00 72.00 4.00 53.00
It should show $4 in the column with the 53. Any thoughts? I can manually correct this (and a couple others) but curious what the correct fix would be?
Would this work? If dues are less than 125, it uses the difference of that number instead of 125. The Max just makes it so if they owe a negative amount it rounds up to 0.