how do i use a formula to work a precentage of a percentage

G

Guest

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?
 
G

Guest

Actually, 60% of 3% is 1.8%.

C1: = A1*B1

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

Tom Ogilvy

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top