Philipp Giddings wrote:
Hello all
Trying to create an If statement that will multiply cell value under
10 by 2.5 and 10 and over by 2.5
my non functioning formula below
=IF(I2<10);(I2*2.5) IF(I2=>10;(I2*2.4)))
any help would be appreciated
Thanks
Philipp
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
You only need one IF: IF(I2<10;I2*2.5;I2*2.4)
An IF has three parts separated by semicolons. These are:
1. the condition to be tested; in this case "if I2 is less than 10"
2. the action to take if the condition is true; in this case,
"multiply I2 by 2.5"
3. the action to be taken otherwise (if the condition is false); in
this case "multiply I2 by 2.4"
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
