formulas

[greeniz61]

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

[BenjieLop]

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.

[Rowan Drummond]

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)