Percentage formula

  • Thread starter Thread starter Richard Parker
  • Start date Start date
R

Richard Parker

Hello

I need an excel formula to work the following for bonuses/penalties

For example as a penalty

Cell A1 has the cost say £100
In cell A2 you input a percentage (i.e. 50 per cent)
Cell A3 outputs the answer as £50

In another chart I need it to do the opposite

For example as a bonus

Cell A1 has the cost say £100
In cell A2 you input a percentage (i.e. 50 per cent)
Cell A3 outputs the answer as £150

Can anybody help?

Many thanks
 
Hi Richard
for the first one enter the following in A3
=A1*A2
and format this cell as currency

For the second one try
=A1*(1+A2)
and format as currency
 
Hi Richard!

Use:
=A1*A2

For adding 50%

=A1*(1+A2)

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top