Hi All, been racking my brains on this one, looked at loads of examples. I think I just do not understand the structure of combining the if and or statements as I have written it down and it makes sense to me.
Basically I am working out employer Pension contributions.
The formula in my head goes like.
If D2 = Y (this states they are in pension)
then
If Gross>865 the cell = (753 x 1%) Or If Gross > 113 and <866 the cell = (Gross-113 x 1%)
Else cell = 0
Maybe I am missing something. I tried but I seem to be going round in circles. Is there a logic builder app
Thanks for looking
N
Basically I am working out employer Pension contributions.
The formula in my head goes like.
If D2 = Y (this states they are in pension)
then
If Gross>865 the cell = (753 x 1%) Or If Gross > 113 and <866 the cell = (Gross-113 x 1%)
Else cell = 0
Maybe I am missing something. I tried but I seem to be going round in circles. Is there a logic builder app
Thanks for looking
N