Excel 2010 formula help

Many AP members are knowledgeable about computers. Ask questions and share your knowledge here. (Information are supplied without any guarantee. Do not open any URL or file not posted by someone you know.) (All users can read)
Post Reply
Elrojo
BacoTroll
Posts: 2517
Joined: Fri Jun 27, 2008 10:18 am
Location: Australia

Excel 2010 formula help

Post 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
User avatar
tommytanker
Maxi Leet
Posts: 437
Joined: Wed Jun 13, 2007 8:41 pm
Location: Texas

Re: Excel 2010 formula help

Post by tommytanker »

Image
Porvalsh
Little Leet
Posts: 25
Joined: Sun Oct 07, 2012 12:33 pm

Re: Excel 2010 formula help

Post 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
Entevenr - Crat
Ficksterama - Fix
Porv - Adv
Elrojo
BacoTroll
Posts: 2517
Joined: Fri Jun 27, 2008 10:18 am
Location: Australia

Re: Excel 2010 formula help

Post by Elrojo »

Thanks Polv.

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