formulas
How to make "cell C" minus 30% show up in "cell D" (ex: $5-30%=$3.50)
|
formulas
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 |
formulas
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) |
All times are GMT +1. The time now is 10:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com