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

%3CLINGO-SUB%20id%3D%22lingo-sub-2349096%22%20slang%3D%22es-ES%22%3Eadd%20a%20number%20%22n%22%20every%20time%20my%20cell%20exceeds%20a%20certain%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2349096%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20morning%2C%20%3CBR%20%2F%3E%20I%20would%20like%20to%20know%20if%20anyone%20knows%20a%20formula%20that%20allows%20me%20to%20add%20a%20number%20%22n%22%20every%20time%20my%20cell%20exceeds%20a%20certain%20value%2C%20ie.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3Eif%20Cell1%26gt%3B30%20then%20%22add%202%22%20in%20Cell%202%20%3CBR%20%2F%3E%20then%20I%20would%20like%20my%20Excel%20to%20do%20the%20following%3C%2FP%3E%3CP%3ECell1%20x%2031%20%3CBR%20%2F%3E%20Cell2%20x%2033%3C%2FP%3E%3CP%3Eotherwise%20...%3C%2FP%3E%3CP%3ECell1-35%20%3CBR%20%2F%3E%20Cell2-41%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2349096%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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