Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
=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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frequency formula | Excel Worksheet Functions | |||
Polynimial trandline formula | Charts and Charting in Excel | |||
formula won't work | Excel Worksheet Functions | |||
formula won't work | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |