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

Suggested Topics

2
Online

390
Users

384
Topics

1.7k
Posts

Copyright © 2021 | info@shutfim.com