Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,393
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,059
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
percentage calculation Gabriel Excel Discussion (Misc queries) 1 August 28th 06 09:31 AM
'of' percentage with calculation (attempt 2) Steve Crowther Excel Discussion (Misc queries) 4 May 22nd 06 12:58 PM
'of' percentage with calculation Steve Crowther Excel Discussion (Misc queries) 2 May 22nd 06 09:58 AM
Percentage calculation Roz Excel Discussion (Misc queries) 5 January 6th 06 08:05 PM
Percentage Calculation clandis Excel Worksheet Functions 5 July 21st 05 07:38 PM


All times are GMT +1. The time now is 12:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"