Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Natalie
 
Posts: n/a
Default how do i use a formula to work a precentage of a percentage

HI,
How do I work out this:

If the total bonus a person could receive was 3% of their salary, but they
were only entitled to 60% of the bonus. How do I work it out from:

A B C
1 60% 3% ?

If Cell A was the amount the individual was entitled to, and Cell B was the
percentage of the salary offered, how do I get the result (which should be
1.2%) appear in Cell C?
  #2   Report Post  
Ron Coderre
 
Posts: n/a
Default

Actually, 60% of 3% is 1.8%.

C1: = A1*B1

Example:
$100 x 0.03 = $3.00
$3.00 x 0.6 = $1.80

--
Regards,
Ron

  #3   Report Post  
Tom Ogilvy
 
Posts: n/a
Default

=A1:B1
and format as percent (with at least one decimal place)

But I get an answer of 1.8%

If I made $100, then 3% of that is $3. 60% of $3 is $1.80, not $1.20

--
Regards,
Tom Ogilvy

"Natalie" wrote in message
...
HI,
How do I work out this:

If the total bonus a person could receive was 3% of their salary, but they
were only entitled to 60% of the bonus. How do I work it out from:

A B C
1 60% 3% ?

If Cell A was the amount the individual was entitled to, and Cell B was

the
percentage of the salary offered, how do I get the result (which should be
1.2%) appear in Cell C?



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
Frequency formula Curious Excel Worksheet Functions 1 April 12th 05 09:49 PM
Polynimial trandline formula CLR Charts and Charting in Excel 9 February 7th 05 07:31 PM
formula won't work tink13ub Excel Worksheet Functions 1 January 17th 05 06:59 AM
formula won't work Linette Excel Worksheet Functions 0 January 17th 05 06:05 AM
Help with macro formula and variable Huge project Excel Worksheet Functions 0 December 28th 04 01:27 AM


All times are GMT +1. The time now is 08:41 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"