Thread: I need a formula to get a 15% discount from a # like $452,472.00
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Vito
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote