2010/1/22 Philipp Giddings <[email protected]>: > 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)))
Seems like you misunderstood the syntax a bit there. As someone already mentioned, the syntax is: =IF(Condition;Value/statement if condition is true;Value/statement if condition is false) You can have an IF condition inside another one and so on: =IF(A1<-15;"A1 & " ℃ is rather cold";IF(A1>35;A1 & " ℃ is hot";A1 & " ℃ is quite allright")) Regards Johnny Rosenberg > any help would be appreciated > Thanks > Philipp > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
