New Contributor

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.  I would like the new column to add any amount over \$300 to the new column (as the amount due).

Thanks.

3 Replies

Re: Formula Creation

Here is a small example in the attached file.

=IF(A1>=300,"Over Limit",A1)

If not what you want, please provide more detailed information,

simply step by step explanation to provide a better and more accurate solution proposal.

Thank you

NikolinoDE

I know I don't know anything (Socrates)

Re: Formula Creation

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.

Re: Formula Creation

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