How to make "cell C" minus 30% show up in "cell D" (ex: $5-30%=$3.50)

greeniz61 Wrote:
How to make "cell C" minus 30% show up in "cell D" (ex: $5-30%=$3.50)


Your formula is

=C1*(1-PERCENTAGE)

where C1 is, for example, where $5 is entered.


Regards.


--
BenjieLop


------------------------------------------------------------------------
BenjieLop's Profile: http://www.excelforum.com/member.php...o&userid=11019
View this thread: http://www.excelforum.com/showthread...hreadid=477785

One way:
in D1 enter =C1*0.7

Hope this helps
Rowan

greeniz61 wrote:
How to make "cell C" minus 30% show up in "cell D" (ex: $5-30%=$3.50)