Hi All
I have the following
A1 - Unit Price (Numbers)
B1 - % Discount (Numbers)
C1 - Discount Value (Numbers)
D1 - Line Total
What im trying to get is a sum in C1 that shows me the value of the discount
Example
A1 = 795
B1 = 10
C1 = Answer should be 79.5
I can only get it to show 715.50 which is 795 less 10 percentage
What should the calculation be
Thanks inadvance
Bookmarks