@SilverMoon Doesn’t seem to be working anymore…
Automatic calculation in excel

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?

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