help with formulas

ferrarifx · #1 11-15-2016, 07:39 AM

Hi can any one help,I am trying to work out how to do a formula in excel but don't know how to write it.

I need to add a 75% profit and 20% tax to a £1.00.

On paper I do
1.00+0.2=1.2
x100=120
divided by 25 which equals £4.80 selling price.

hope this makes sense

xor · #2 11-15-2016, 09:23 AM

With

1 in B1
0.2 in B2
0.75 in B3

=B1*(1+B2)/(1-B3)

ferrarifx · #3 11-16-2016, 12:04 PM

thank you for the help,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA formulas	zhead	Excel Programming	17	02-09-2016 03:41 AM
Using Right and Len formulas together	PDGood	Excel	4	11-20-2015 06:50 AM
formulas	MSA5455	Excel	3	12-19-2014 01:50 AM
Need help with formulas please	paul_pearson	Excel	0	03-20-2013 06:51 AM
IF Formulas	mizzamzz	Excel	1	07-08-2010 02:32 AM