how can I insert a function of this type: if the value of cell A1 is more than 35, multiplies x 2, and if it is less than 35, multiplies x 3? Thanks to those who can help me
View best response
If you want a function you have to program a UDF in VBA.
If you can settle with a formula:
Hi @Barbara Pansa
If you were also wanting to include 35 in the formula (e.g A1 is more than or equal to 35) then just add a = in the criteria to @Lorenzo Kim's answer: