@TroubleMaker, Ha ha, same here, nice to get a reminder once in a while.
@Hacker26 nothing I can think off, I don’t think anyone here will be able to guide you on Issues obviously much bigger then this forum.
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
