Automatic calculation in excel

[PP14]

I try to set up a formula in excel which would give results as follows: 1 piece should cost $1, 50 pieces should cost 90c, 100 pieces should cost 80c etc., so let say one buys 86 pieces would cost $77.40, could anyone help with this please?

[avi klaine]

You must create a table and in the cell next to the number of items you will copy it

=IF([@1]<50,[@1]*1,IF([@1]<99,[@1]*0.9,[@1*0.8))

Change @ 1 to the name of your column and leave the strudel