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?
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?