Skip to main content

How do I delete a Formula?

If the Formula is no longer required

Sandra McCarthy avatar
Written by Sandra McCarthy
Updated this week

Delete Formula for a whole row in the budget

To delete a Formula from a whole row, you can type a 0 into the Total Column, this will give you a warning, and you will need to confirm the action by clicking

DELETE FORMULAS

Delete Formula from a point in time

To delete the Formula from a specific time period forwards, in the first individual cell highlight the value and then overtype the value with a 0, this will remove the Formula from just that cell, you can then click on the cell again and on the overflow (...) choose Copy to future and it will remove the formula for the rest of the period you have selected.

Delete a Formula for one cell only

To delete a Formula from an individual cell with a value in it, just highlight the value and then overtype the value with a 0, this will remove the Formula from just that cell.

If the value of the cell is already 0, but you wish to remove the Formula, type a 1, and then when the Formula is removed, return the value to 0.

Update or Change a Formula

If you need to update a Formula, click the cell or cells you wish to change, select Formula from the overflow (...) and make the changes you require. Then click

APPLY FORMULA to confirm the change.

For full details of the Formula settings, see Budgets & Scenarios: Formulas

Did this answer your question?