set up a table with the quantity to sell in one column and the corresponding
credit in the next column.

Then you can use a Vlookup formula using the actual amount sold as the
lookup value to return the credit.

See the help on Vlookup to see what you need to do.

--
Regards,
Tom Ogilvy

"Viviank" wrote in message
...
I volunteered to help set up a spreadsheet for a school fundraiser. I
need
help with a formula. The teacher wants to keep track of student profits.
Basically, if a student sells 1-10 items, they receive $20 of credit, if
they
sell 11-20 items, they receive $20 in the account, etc, How would I set up
a
formula like that?? HELP

Vivian K