Forum time display is UTC  





Post new topic Reply to topic
  Print view

  Excel 2010 formula help
Author Message
    PostPosted: Thu Dec 06, 2012 8:34 am 
BacoTroll
Offline

Posts: 2520
Joined: Fri Jun 27, 2008 10:18 am
Location: Australia
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


Top
 
 Profile  

 

  Re: Excel 2010 formula help
    PostPosted: Thu Dec 06, 2012 5:57 pm 
Maxi Leet
User avatar
Offline

Posts: 440
Joined: Wed Jun 13, 2007 8:41 pm
Location: Texas
I think this could help:
http://office.microsoft.com/en-us/excel-help/if-HP005209118.aspx?CTT=5&origin=HP005251012

_ _ _ _ _ _ _ _ _ _ _ _ ____
Image


Top
 
 Profile  

 

  Re: Excel 2010 formula help
    PostPosted: Thu Dec 06, 2012 9:17 pm 
Little Leet
Offline

Posts: 25
Joined: Sun Oct 07, 2012 12:33 pm
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


Top
 
 Profile  

 

  Re: Excel 2010 formula help
    PostPosted: Thu Dec 06, 2012 9:40 pm 
BacoTroll
Offline

Posts: 2520
Joined: Fri Jun 27, 2008 10:18 am
Location: Australia
Thanks Polv.

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


Top
 
 Profile  

 

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 4 posts ] 

Forum time display is UTC  


  Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Athen Paladins is a large and old Organization of players ("Guild") founded in June 2003 in Anarchy Online,
a SF MMORPG created and published by Funcom (www.anarchy-online.com)
The names Anarchy Online and Funcom are the property of Funcom, Norway.
All trademarks and copyrighted material on this site are the property of their respective owners. All rights reserved.
This site is a non-profit and non-commercial site, solely made for the entertainment of Anarchy Online players.
Athen Paladins is a non-profit association
Athen Paladins theme created by © Chrisax, based on 4poziom by © gokin (www.gokin.pl), and Subsilver2 & Prosilver by © phpBB (www.phpbb.com)
Powered by phpBB © 2000, 2002, 2005, 2007, 2008 phpBB Group - Modifications by Chrisax and other authors.

W3 Consortium CSS approved