If I enter between 50 and 99 I would like the cell to enter 3, between
100-150, 5 should go in the cell and above 151 I would like the cell to read
7.
Any help would be appreciated

Try something like the following:

=IF(A1<50,"???",IF(A1<100,2,IF(A1<151,3,7)))

You don't specify what value is to be returned if the value is <50. The
formula will return "???". Change as needed.


--
Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)



"Confused in Nebraska" <Confused in
wrote in message ...
If I enter between 50 and 99 I would like the cell to enter 3, between
100-150, 5 should go in the cell and above 151 I would like the cell to
read
7.
Any help would be appreciated

I'm trying to make a spreadsheet for a fantasy football league. How do I get
the formula to read the cell for my scoring? Example: 0-150 =0, 151-200 = 3,
201-250 = 4, ect. I can only get it to read one equation or give just a word
FALSE instead of assigning the values

Assume you enter the score in A1


=IF(A1="","",VLOOKUP(A1,{0,0;151,3;201,4;251,5;301 ,6;351,7;401,8},2))


this will go up to 401 and 8


replace all occasions of A1 in the formula with the cell where you put the
score
--


Regards,


Peo Sjoblom

"Confused in Nebraska" wrote
in message ...
I'm trying to make a spreadsheet for a fantasy football league. How do I
get
the formula to read the cell for my scoring? Example: 0-150 =0, 151-200 =
3,
201-250 = 4, ect. I can only get it to read one equation or give just a
word
FALSE instead of assigning the values