ExcelBanter - discount formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - discount formula (https://www.excelbanter.com/excel-discussion-misc-queries/257817-discount-formula.html)

Ayman

discount formula

if A2=500 A3 20% discount A4 net amount what the formula is ?for A4

Jacob Skaria

discount formula

=A2-A2*A3

OR

=A2*(1-A3)

--
Jacob

"Ayman" wrote:

if A2=500 A3 20% discount A4 net amount what the formula is ?for A4

All times are GMT +1. The time now is 06:35 PM.