Calculating a bonus. It is a base dollar amount multiplied by a calculated percentage. I need this to then give me a dollar amount of what their bonus should be.I need an excel formula that will calculate a dollar amount times a percentage to give me a $$ amount?
you can use cell formatting for get the $ signs.
to answer this there are a few things that come into play, the format of the percentage? a whole number like (45) or a decimal (0.45) we will want to work with a decimal, so if you have a whole number the formula to get the bonus should look something like this:
=A1 * (A2 / 100)
where A1 is the base dollar amount, and A2 is the percentage.
if the percentage is a decimail (0.45) then you will not need to add the / 100 in.
i hope this helps.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment