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