Hello,

I am using a spreadsheet for my partners bookkeeping. In column f27 I have the amount before tax. I need a formula that will in the next box take off 20%. I have spent around two hours today googling this and the suggestions don't work. I'm off laptop now, but the popular one seemed to be *f27/20% . that formula does calculate something, but not what I want.
If column f27 has £100 in how do I calculate 20% as that is his tax owed. And then in the next column I will minus g27 from f27 to have the amount.

Please help.

I didn't find the right solution from the internet.

References:
https://forum.openoffice...opic.php?f=9&t=85086 
Recycle Management Solution Video 

Thank you.

ezPaycheck payroll software calculates payroll taxes automatically based on federal and state tax tables. Are you in US?


I am not sure which tax you have question. Would you please give us more details? ie: state tax, SS tax, SUTA or others? We are glad to assist you.


Thank you.

---