Question about excel formula
Suppose I have a rule:
If a number is equal to greater than 10, I want the number multiplied by 3.
If a number is less than 10, I want the number multiplied by 2.
Is there a way I can setup a formula in excel such that if I enter a number equal to or greater than 10, it multiplies by 3. And if I enter a number less than 10 in the same cell it automatically multiplies by 2, pursuant to the rule above?