Percentage formula

[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

 

[Frank Kabel]

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

 

[Norman Harker]

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.

 

[Richard Parker]

In message <#[email protected]>, Frank Kabel

Just perfect, thank you very much