ExcelBanter - I need a formula to get a 15% discount from a # like $452,472.00

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

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - I need a formula to get a 15% discount from a # like $452,472.00 (https://www.excelbanter.com/charts-charting-excel/58449-i-need-formula-get-15%25-discount-like-%24452-472-00-a.html)

tia

I need a formula to get a 15% discount from a # like $452,472.00

help with formulas

Vito

I need a formula to get a 15% discount from a # like $452,472.00

If your number is in cell A1,

then to get discount amount to apply: =A1*.15

to apply the discount immediately: =A1-A1*.15

--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=490185

All times are GMT +1. The time now is 11:16 PM.