I need your help

[ajonline]

I didnt know exactly where to put this. But I am doing some work on my new business that will be starting soon, but i need some help in excel.

I need a formula to find out how much net Profit we will earn once Paypal fees have been deducted. I could go through and work it out for all of my products but theres quite a few.

E.G
Revenue Gross Profit Net Profit
£200 £50 £43 *

*Need formula for this to be worked out automatically.

As i need to deduct 3.4% + .20p from my gross profit to get my net profit, due to the charges of the £200 i will receive.

Can any one help?

Much Appreciated

Adam

 

[vdeep.com]

= X - ((X * 0.034) + .2)

where X is the cell reference value

that should do it i think

 

[ajonline]

= X - ((X * 0.034) + .2)

where X is the cell reference value

that should do it i think

yup, exactly what i needed

thanks very much