I’m creating a spreadsheet to help keep logs of jobs I do daily and weekly. I need a formula to add rows in a column, then subtract a certain amount as long as the amount is over a certain amount..
I have 4 or 5 rows that the amounts are over $51.00
I need to add those rows and then subtract $14.00 from each
unless the amount is under $51.00 then I need to subtract $6.00
By: Kelly Kopke