Ok,
profit sheet.
1 box with total profit, one box under it for tax deduction, one box below that for total.
I want to take 22% off whatever figure is in my pre tax box above. I just cant find the formula to use. Excel could be made much better than it is for begginers.

Can anyone help.

mat

Hi Math,

Formuala for tax would be =sum(cell reference of profit/100*22)

Example: =sum(d4/100*22)

thanks madmonkey again. thant did the trick purfect!

Nice MM

Marked as [Answered]