Page 1 of 1

Excel 2010 formula help

Posted: Thu Dec 06, 2012 8:34 am
by Elrojo
Hey guys,

I need to write a seemingly simple formula in excel but for the life of me I cant work out how to do it.

basically all I want to do is to say Add 10 to a number if the number is less than 50, add 20 to the number if the number is greater than 50.

helpz

Re: Excel 2010 formula help

Posted: Thu Dec 06, 2012 5:57 pm
by tommytanker

Re: Excel 2010 formula help

Posted: Thu Dec 06, 2012 9:17 pm
by Porvalsh
Since you just have two possible conditions you can use IF statement. However, what happens if you have a 50?

=IF(A2<=50,A2+10,A2+20)

24 34
40 50
49 59
50 60
51 71
52 72
60 80
100 120

Re: Excel 2010 formula help

Posted: Thu Dec 06, 2012 9:40 pm
by Elrojo
Thanks Polv.

I wont ever have exactly 50. Its a $ value so they will be never exactly 50.