 |
|
03-06-2008, 07:55 PM
|
#1 |
|
Tri-State Addict
Join Date: Jan 2007
Location: Baltimore,MD and York,PA
Member #3470
My Ride: Nissan S13 iTrader: (0)
 |
Homework Help needed (MS Excel)
I'm trying to make an equation that I insert in a cell on MS Excel, but I'm not sure what to type in or if I have to use some sort of solver. What I need to do is if a certain cell, let's say A1, is less than or equal to 62,500, insert the number '1'. If cell A1 is between 62,501 and 125,000, insert the number '2'. If cell A1 is between 125,001 and 187,500, insert the number '3'. I only need it to go up to 3. Can anyone tell me what the equation is I need in order to make that happen or what sort of tool I need to use to do that? Thanks! -Jesse BTW, I'm using Excel 2003 if it makes a difference. |
|
|
|
03-06-2008, 08:59 PM
|
#2 | ||
|
Tri-State Aficionado
|
Um..try the If function
=if(condition, returned value if condition is true, returned value if condition is false)
__________________
Fighting is like an ocean. Im a shark, and most people can't even swim. Quote:
Quote:
|
||
|
|
|
|
03-06-2008, 09:06 PM
|
#3 |
|
Tri-State Post Whore
|
booyakasha!
=IF(A1<=62500,1,IF(A1<=125000,2,IF(A1<=187500,3)))
__________________
The Pirates of Death and Destruction set out to annihilate and humiliate through Brutal Carnage. You gonna drive it, or buy it a dress? To view links or images in signatures your post count must be 10 or greater. You currently have 0 signatures. |
|
|
|
|
03-06-2008, 09:10 PM
|
#4 | |||
|
Tri-State Aficionado
|
Quote:
__________________
Fighting is like an ocean. Im a shark, and most people can't even swim. Quote:
Quote:
|
|||
|
|
|
|
03-06-2008, 09:14 PM
|
#5 |
|
Tri-State Post Whore
|
worked for me?
edit: lol alright!
__________________
The Pirates of Death and Destruction set out to annihilate and humiliate through Brutal Carnage. You gonna drive it, or buy it a dress? To view links or images in signatures your post count must be 10 or greater. You currently have 0 signatures. |
|
|
|
 |
| Bookmarks |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| javascript homework help | STiGuy06 | Off-Topic | 3 | 02-11-2010 03:36 PM |
| Help with my homework? | dragonfly2k3 | General Car Related Chat | 7 | 02-23-2008 05:44 AM |
| If anyone is up help me with my Philosophy Homework!!! | maximaserg | Off-Topic | 17 | 02-17-2008 01:55 AM |
| Database Help - Excel, Acces, etc. | PotenzaSub | Off-Topic | 4 | 01-15-2007 11:12 AM |
Linear Mode
