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
A
Best posts made by avi klaine
-
RE: Automatic calculation in excelposted in Software
Latest posts made by avi klaine
-
RE: Automatic calculation in excelposted in Software
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