ANSWERS: 2
  • if you want a increase a single cell to be increased by four it would just be +4 and If you would like a column (using column A as the example) to incrementally increase by four it would be =sum(a1+4) and then drag the box down the column and it will autofill.
  • On the face of it this is simple (say cell A1 contains 50, so in A2 put the formula =A1+4), but you say IN a cell, not in ANOTHER cell. I think I would use the formula above and then hide the column containing the original figures so that it appeared the cell itself had changed. If the value in the cell is derived from a formula (say, =A6*B6) then you can edit the formula to read =A6*B6+4, but if it's a directly entered figure it's more problematical. If increasing the value by 4 is subject to some condition then you would achieve what you want by using the IF worksheet function.

Copyright 2023, Wired Ivy, LLC

Answerbag | Terms of Service | Privacy Policy