G
Guest
thanks for getting back to me,
still having problems getting #Div/0!
think its the way i've constructed the table?
A1 = Gross earnings
B2 = frequency of pay ( in my case 26 for fortnightly)
C1 = tax band 5035
C3 = 0
C4 = 5044
C5 = 33540
D3 = 0%
D4 = 11%
D5 = 1%
A7 = =SUMPRODUCT(--(A1>C3:C5/B2),A1-C3:C5/B2,D3
5-D2
4)
just incase i get same problem with income tax can you help with that aswell
p.s. i can now see how 7185 band is worked out thank you very much.
when all is working i'd like you to have a look a the calculator if possible
is there any way i can send you it?
then you can see what i'm trying to do, and would welcome any feed back on it
theres probably an easer way to do what i've done but just learning, thats
why all the questions.
still having problems getting #Div/0!
think its the way i've constructed the table?
A1 = Gross earnings
B2 = frequency of pay ( in my case 26 for fortnightly)
C1 = tax band 5035
C3 = 0
C4 = 5044
C5 = 33540
D3 = 0%
D4 = 11%
D5 = 1%
A7 = =SUMPRODUCT(--(A1>C3:C5/B2),A1-C3:C5/B2,D3


just incase i get same problem with income tax can you help with that aswell
p.s. i can now see how 7185 band is worked out thank you very much.
when all is working i'd like you to have a look a the calculator if possible
is there any way i can send you it?
then you can see what i'm trying to do, and would welcome any feed back on it
theres probably an easer way to do what i've done but just learning, thats
why all the questions.