Hi!

Create a small table somewhere on you sheet:

0 0
100 1
200 2
300 3
400 4
500 5
600 6
700 7
800 8
900 9
1000 10


Assume this table is in the range G1:H11

Cell A1 holds the sales amount:

A1 = 219

=VLOOKUP(A1,G1:H11,2,1)

Biff

"Trisha V via OfficeKB.com" wrote in message
...

Biff, thanks for your helping me out....what Im working on is a contest
where
depending on how much someone sells they get certain pulls out of a hat
with
money on them....If they sell from $100 to $199, they get 1 pull,
$200-$299
they get 2 pulls, etc etc etc ... and they can only get up to 10
pulls...Hope
this helps....

Biff wrote:
Hi!

=IF(G9100,1,IF(G9200,2,IF(G9300,3,)))

If all you needed to check were the 3 conditions in your sample then you
simply need to reverse the logic:

=IF(G9300,3,IF(G9200,2,IF(G9100,1,"not defined")))

Since you have 10 conditions you want to test for, using IF won't work.

What do you want to happen if G9 < 100?

What do you want to happen if G9 = 100, 200, 300 etc.?

Biff

Im working on a formula that looks somewhat like this:

[quoted text clipped - 7 lines]

WHAT AM I DOING WRONG? CAN SOMEONE PLEASE HELP ME?