Forum Discussion
Formula Creation
How do I create a formula that will automatically add an amount to a different column once it exceeds a certain dollar amount? For example, $300 is the limit. Once the amount is over this limit...
Okay, thanks for responding here's what I would like to have...
For example, my company gives me a $300 advance as petty cash, most of the time that amount is used before the end of the month. I then have to use my own money after that amount is used. I would like to have the formula to start adding any amount that I am out-of-pocket for costs after the $300. I also itemize what was spent, 8.26 for this or that... 9.99 for...
I want the formula to calculate any amount after the $300 is used as money owed to me by the company.
For example, my company gives me a $300 advance as petty cash, most of the time that amount is used before the end of the month. I then have to use my own money after that amount is used. I would like to have the formula to start adding any amount that I am out-of-pocket for costs after the $300. I also itemize what was spent, 8.26 for this or that... 9.99 for...
I want the formula to calculate any amount after the $300 is used as money owed to me by the company.
You can try the equation below that way it subtracts 300 from the total so anything in the positive is what the company owes you.
=SUM(A1:A100)-300
=SUM(A1:A100)-300