add a number "n" every time my cell exceeds a certain value

Copper Contributor

Good morning,
I would like to know if anyone knows a formula that allows me to add a number "n" every time my cell exceeds a certain value, ie.


if Cell1>30 then "add 2" in Cell 2
then I would like my Excel to do the following

Cell1 = 31
Cell2 = 33

otherwise ...

Cell1=35
Cell2= 41

0 Replies