Hi Paulina

i think driller was trying to point out that as it stands, Gary's
formula would charge 50 for orders of 1,2,3 and 4.
Either put another condition in, using your retail price - say 80, for
amounts less than 5 or go with Farhads solution

=IF(A1<5,80,IF(A1<50,50,IF(A1<100,48,46)))*A1

As far as Protecting the formula is concerned, all cells are locked by
default, and as soon as you apply Password protection to the sheet the
cell becomes locked.
What you will nedd to do, is mark the range of cells where you want
users to be able to enter data, then
FormatCellsProtectionremove the check mark from Locked.

ToolsProtectionProtect Sheet You need not bother to give a password
if you don't want to. If you do, be sure to write it down somewhere.

Be aware that even with a password, you cannot really protect a sheet
from someone changing things if they are determined.
Also, be aware that password protection does prevent the use of some
other functions.
--
Regards

Roger Govier


"paulina_rockstar" wrote in
message ...
No we don't except orders less than 5 boxes at wholesale prices.

"driller" wrote:

Do you accept orders less than 5 boxes?

regards,
driller
--
*****
birds of the same feather flock together..



"paulina_rockstar" wrote:

PLEASE HELP!!

I am trying to do tier pricing on a worksheet. This is the help
that I
need. If someone orders 5-50 boxes the price will be $50 per box,
51-99
boxes the price will be $48 per box, 100+ boxes will be $46 per
box. Can
someone please help me.

I would be very grateful.