Percentages

[Guest]

Can anyone help

What formula will add a percentage to a value so i can get a gross value from nett

 

[Norman Harker]

Hi Tina!

To add a percentage to a figure use:
=A1*(1+B1)
where B1 is a percentage.

But if you have the net value which is obtained by deducting a
percentage from the gross use:
=A1/(1-B1)
Derives the gross from which the percentage in B1 was deducted
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Can anyone help!

What formula will add a percentage to a value so i can get a gross

value from nett

 

[Frank Kabel]

Hi
e.g. to add 15% try
=A1*1.15
if A1 stores your net value

 

[Guest]

----- Norman Harker wrote: ----

Hi Tina

To add a percentage to a figure use
=A1*(1+B1
where B1 is a percentage

But if you have the net value which is obtained by deducting
percentage from the gross use
=A1/(1-B1
Derives the gross from which the percentage in B1 was deducte
--
Regard
Norman Harker MVP (Excel
Sydney, Australi
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments
available free to good homes

Can anyone help

value from net

Thanks Norma

Are you in Sydney, i was there for a few year

Thanks for your hel

 

[Bob Phillips]

=A!*(1+15%)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Can anyone help!

What formula will add a percentage to a value so i can get a gross value

from nett