Sep 16 2022 09:36 AM
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.
Sep 16 2022 09:48 AM
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
I know I don't know anything (Socrates)
Sep 16 2022 10:01 AM
Sep 16 2022 09:37 PM