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