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)

This post is also available in Deutsch.

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

Leave a Reply

Your email address will not be published.