Forum Discussion
Excel Formulas and Functions
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.. ...
Man Fai Chan . I see your formula is correct to subtract either 14 or 6 based on column A. Adding or deleting rows are VB/Macro area. It must be disappointing to you but formula only can do affect a cell by calculation using other cell info.
J
Is there a way to do it so it calculates as I put in the numbers in the total cell?