If this and that!

[Nygie]

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

 

[Nygie]

Nearly there
=IF(D2="Y",IF(Table6[[#This Row],[Gross £]]>865,753*0.01,IF(AND(Table6[[#This Row],[Gross £]]>113,Table6[[#This Row],[Gross £]]<865),(Table6[[#This Row],[Gross £]]-113)*0.01)),0)
Sorry for the table references lol

 

[Nygie]

Shorter version

=(D2="y")*IF(E2>865,7.53,IF(E2>113,E2-1.13))

That works too with the same change.
Thank you

 

[Nygie]

Thank you both for your replies.
Very helpful, I was nearly there I had my Y/N conditioning met but could not get the formula to do me sums!

Thanks again

 

[snjpverma]

Glad to help