multipying a cell by a percentage
I want to know how to multiply a single cell by a percentage.
ie: 2000.00 x 17.5% or 2500.59 x 30% Does anybody know how to do this, appreciate your responses. |
multipying a cell by a percentage
Try,
For 30% =A1*1.3 For 17.5% =A1*1.175 Mike "jjbits4u" wrote: I want to know how to multiply a single cell by a percentage. ie: 2000.00 x 17.5% or 2500.59 x 30% Does anybody know how to do this, appreciate your responses. |
multipying a cell by a percentage
have notice that on the Mike's answer you will add 17,5% or 30% to the
amount, to have inly 30% of a value use a1*0.3 hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Mike H" escreveu: Try, For 30% =A1*1.3 For 17.5% =A1*1.175 Mike "jjbits4u" wrote: I want to know how to multiply a single cell by a percentage. ie: 2000.00 x 17.5% or 2500.59 x 30% Does anybody know how to do this, appreciate your responses. |
multipying a cell by a percentage
The OP didn't ask for an *increase* by a percentage, but for a
*multiplication* by a percentage. Hence =A1*17.5% or =A1*30% -- David Biddulph "Mike H" wrote in message ... Try, For 30% =A1*1.3 For 17.5% =A1*1.175 Mike "jjbits4u" wrote: I want to know how to multiply a single cell by a percentage. ie: 2000.00 x 17.5% or 2500.59 x 30% Does anybody know how to do this, appreciate your responses. |
multipying a cell by a percentage
Does anybody know how to do this, ???
A "percentage" .... in a "single cell", you say. Hmmmmmmmmm. Well, I think there was someone who knew how to do that, but unfortunately he died in 1987. So we're all sitting here waiting for someone else to come along and work it out. It's a darn good question and we'll let you know if we work it out. See ya! Zumble. "jjbits4u" a écrit dans le message de news: ... I want to know how to multiply a single cell by a percentage. ie: 2000.00 x 17.5% or 2500.59 x 30% Does anybody know how to do this, appreciate your responses. |
All times are GMT +1. The time now is 11:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com