Need help with %

[yvonne7]

Please can someone help me with a problem I am having with %

GROSS SUPER TAX NET
Income - 9% super - 20% = net pay from cel
(D15 ) (E15) (F15) (G15)

I havent used Excel in a long time!
I Would be most great-full for the help

Yvonne

[Bryan Hessey]

Please can someone help me with a problem I am having with %

GOSS SUPPER TAX NET
Income - 9% supper - 20% = net pay from cel
(D,15 ) (E,15) (F,15) (G,15)

I havent used Excel in a long time!
I Would be most great-full for the help

Yvonne

Hi,

was that 20% of D15 or 20% of D15-9%


something like

in E15
=D15*0.09

in F15
=D15*0.2

in G15
=D15-E15-F15

should help
---

[yvonne7]

Hi Bryan

It is ment to be eg:
Goss income in (D,15)
-9% supper (E,15)
-20% tax (F,15)
= net pay (G,15)

I get what you mean many thank's
Yvonne

[Bryan Hessey]

Hi Bryan

It is ment to be eg:
Goss income in (D,15)
-9% supper (E,15)
-20% tax (F,15)
= net pay (G,15)

I get what you mean many thank's
Yvonne

Hi,

The query was, is it 20% of D15, or 20% or what's left after the 9% is removed.

---

[yvonne7]

Thank's Bryan
It work fine! You gave me what I need to work it out.

Most greatful I've been on it for days

Cheers Yvonne

[Bryan Hessey]

Thank's Bryan
It work fine! You gave me what I need to work it out.

Most greatful I've been on it for days

Cheers Yvonne

OK - good to see it works for you, and thanks for the response

---