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