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. ![Laugh :laugh: :laugh:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f606.png)
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![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Thanks for looking
N
![Laugh :laugh: :laugh:](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f606.png)
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
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Thanks for looking
N