Excel 2010 formula help

[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

[tommytanker]

I think this could help:
http://office.microsoft.com/en-us/excel ... P005251012

[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

[Elrojo]

Thanks Polv.

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