Formula Help

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

303 thoughts on “Formula Help

Comments are closed.