Excel Formula for Discount Price Calculation

=IF(C1="",A1*B1,(100-C1)/100*A1*B1)

A1: Number of items
B1: Price per item
C1: Discount (percent)

Diese Seite ist auch in Deutsch verfügbar.

Posted on 18th January 2016 by . This entry was posted in Notes. Bookmark the permalink.

Leave a Reply

Your e-mail address will not be published.