Hello!
I have a spreadsheet that I use on a daily basis to calculate advances and payments. One column (E5) calculates what type of transaction, payment populates as a positive number and advance populates as a negative number. We have another column (G5) that we only use if there are additional transactions to account for. Column F5 calculates the total amount of the advance or payment from E5 and G5. We do not want to run any transaction unless it is $1,000.00 or more, whether it be for a payment or advance. I can get it to account for the positive (payment) side of it, but I can't figure out the formula for the negative (advance) side. This is my current formula that works for the positive side of it: =IF(E5+G5>=1000,E5+G5,0)
Any help is greatly appreciated, my brain is mush from too many google searches and failed formulas
Bookmarks