Excell Question

[Defc0n6]

Hi,
I am trying to program a excell document to have when calculating scores of leagues over at www.xgplanet.com. While programming it, I ran into a problem. I am using this forumla:
=IF(D2=50,4,1)
In which, if D2 is 50, it would put the answer as 4, and if not, it puts it as 1. That works, but I want to make it a tad bit more complicated. How would I make it so that it could instead of only being 50, it be something like 45-55? Answers are greatly appreciated. Thanks!!!
-Defc0n 6

 

[AtTheGates]

=IF(D2>=45,IF(D2<=55,4,1),1)

 

[Defc0n6]

Holy moly that was fast. Thanks a bunch man!!!

 

[Defc0n6]

Uh oh. it gets even harder . New updated question:
I need it so that instead of just: =IF(D2>=45,IF(D2<=55,4,1),1), it would be something like:
If between 90-99, then display 45.
If between 80-89, then display 40.
If between 70-79, then display 35.

 

[AtTheGates]

=IF(D2>=70,IF(D2<80,35,IF(D2<90,40,IF(D2<100,45))))

 

[Defc0n6]

I hate to ask this, since I should be able to understand how from that post, but I am still pretty confused. So, I ask this... how would I get it to basically work based on this:
100% = 50
90% - 99% = 45
80% - 89% = 40
70% - 79% = 36
60% - 69% = 32
50% - 59% = 26
40% - 49% = 22
30% - 39% = 18
20% - 29% = 15
10% - 19% = 12
01% - 09% = 10
The percent is what is found in D2. If you can't do this, its ok since you already helped me a lot. But if you could, that would be supurb. Thanks!!!
-Defc0n 6

 

[AtTheGates]

Thats is a really long IF statement. Just make a table and lookup the value. Then use something like this =VLOOKUP(D2,D18:E29,2). This works because it is finding the closest thing but you could do it using the upper and lower bounds.

 

[Defc0n6]

I get this far:
"=IF(D2>=70,IF(D2<80,35,IF(D2<90,40,IF(D2<100,45))))"
And it works, but I think I can't put any more ifs inside it. Damn
Whoa, I just realized you posted above me. Reading now...

 

[Defc0n6]

I tried that instead of getting the IF thing to work, and it works supurb! You rock AtTheGates. If you have AIM or MSN, and could supply me with your addy, I would greatly appreciate that, because something tells me I will be asking more questions soon. Then again, working over ATOT is good also. Thanks so much man!!!