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.

Leave a Reply

Your email address will not be published.