simple formula question

  • Thread starter Confused in Nebraska
  • Start date
C

Confused in Nebraska

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
 
C

Chip Pearson

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)
 
C

Confused in Nebraska

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
 
P

Peo Sjoblom

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
 
Top