Trisha,

=IF(G9=1600,10,IF(G9<800,0,INT(G9/100)-6))

$1599.99 will give you 9 pulls
$1600 or more will give you 10 pulls
$799.99 or less will give you 0 pulls
$800 to $899.99 will give you 2 pulls
$900 to $999.99 will give you 3 pulls
etc.

Henry


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

Henry, I want to thank you so much for your help. Its funny you have my
husbands name... thanks again..I have another question.. how would I do a
similar formula if the rules for the contest that Im working on read like
this...If you sell $800 you get 2 pulls (out of a hat) and each additional
$100 you sell you get an additional $100 to a max of 10.

Henry wrote:
Trish,

This is different from what you originally asked.

100 means 101 upwards.
Now you're saying 99 (or =100) =100 upwards.

If this is the case then =INT(G9/100) will do you.

To limit it to a Max of 10 pulls, then

=IF(G9999,10,INT(G9/100))

Henry

Biff, thanks for your helping me out....what Im working on is a contest
where
[quoted text clipped - 28 lines]

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


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200508/1