Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage calculation
I'm trying to adjust fixed numbers in cell's 'A' & 'B' with a number I'm
inputting in cell 'C'. (eg, Cell 'A' has a value of $100.00. I want to decrease this value by a percentage I'm inputting in Cell 'C'. Cell 'B' has a value of $150.00. Again, I'm trying to decrease this number with a percentage in Cell 'D'). I'm sure this is MS Excel 101...........any help would be appreciated. -- Many Thanks, Mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage calculation
In E1 enter =A1*(1-C1) and copy down the column
In F1 enter =B1*(1-D1) and copy down the column best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "mmacnz" wrote in message ... I'm trying to adjust fixed numbers in cell's 'A' & 'B' with a number I'm inputting in cell 'C'. (eg, Cell 'A' has a value of $100.00. I want to decrease this value by a percentage I'm inputting in Cell 'C'. Cell 'B' has a value of $150.00. Again, I'm trying to decrease this number with a percentage in Cell 'D'). I'm sure this is MS Excel 101...........any help would be appreciated. -- Many Thanks, Mike |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage calculation
I must be doing something wrong - didn't work.
The numbers in Columns 'A' & 'B' were not changed when I entered a value in colums 'C' & 'D'. Again, I just want to decrease the values in 'A' & 'B' with a percentage in cell's 'C' & 'D'. Many Thanks, Mike "Bernard Liengme" wrote: In E1 enter =A1*(1-C1) and copy down the column In F1 enter =B1*(1-D1) and copy down the column best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "mmacnz" wrote in message ... I'm trying to adjust fixed numbers in cell's 'A' & 'B' with a number I'm inputting in cell 'C'. (eg, Cell 'A' has a value of $100.00. I want to decrease this value by a percentage I'm inputting in Cell 'C'. Cell 'B' has a value of $150.00. Again, I'm trying to decrease this number with a percentage in Cell 'D'). I'm sure this is MS Excel 101...........any help would be appreciated. -- Many Thanks, Mike |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage calculation
On Oct 21, 7:08 pm, mmacnz wrote:
I must be doing something wrong - didn't work. The numbers in Columns 'A' & 'B' were not changed when I entered a value in colums 'C' & 'D'. Again, I just want to decrease the values in 'A' & 'B' with a percentage in cell's 'C' & 'D'. When you enter the "percentage" in columns C and D, do you enter, for example, 0.05 or 5% (either is correct) or 5 (which is not really a percentage)? I'm guessing the latter. In that case, you could fudge the formulas to accommodate the form of your "percentage". For example: =A1*(1-C1/100) But I think it is more reliable for you to correct the form. You can enter literally 5%, or you can enter 0.05 and be sure use Format - Cell - Number to select Percentage with the desired decimal places. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
percentage calculation | Excel Discussion (Misc queries) | |||
'of' percentage with calculation (attempt 2) | Excel Discussion (Misc queries) | |||
'of' percentage with calculation | Excel Discussion (Misc queries) | |||
Percentage calculation | Excel Discussion (Misc queries) | |||
Percentage Calculation | Excel Worksheet Functions |