Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add percentage to a cell | New Users to Excel | |||
exact percentage of each cell | Excel Worksheet Functions | |||
increase the value of a cell by a percentage | Excel Discussion (Misc queries) | |||
How do I multiply cell value by percentage? | Excel Worksheet Functions | |||
Multipying columns that contail null values | Excel Discussion (Misc queries) |