Nested If in pivot table

[Purplethunder]

Hi Guys,

Just found this forum so hoping you can help!

I have a pivot table with the following nested IF statement in the calculated field section but it only appears to be picking up the >20% part and the *8% bit at the end...any ideas why?

Thanks

[TABLE="width: 1372"]
<tbody>[TR]
[TD="width: 59"]Bonus[/TD]
[TD="width: 1313"]=IF('% Margin'<0,0,IF('% Margin'>20%,'Margin Amount'*25%,IF('% Margin'>19%<20%,'Margin Amount'*20%,IF('% Margin'>18%<19%,'Margin Amount'*15%,IF('% Margin'>17%<18%,'Margin Amount'*10%,'Margin Amount'*8%)))))[/TD]
[/TR]
</tbody>[/TABLE]

 

[sandy666]

'% Margin'>17%<18%

i think here should be AND('% Margin'>17%,'% Margin'<18%)
where '% Margin' can be 17,2% or 17,8%, ... etc

but maybe i m wrong

 

[Purplethunder]

Thanks, our IT man figured it out in the end as below:

[TABLE="width: 1313"]
<tbody>[TR]
[TD="width: 1313"]IFS('% Margin'>20%,'Margin Amount'*25%,'% Margin'>19%,'Margin Amount'*20%,'% Margin'>18%,'Margin Amount'*15%,'% Margin'>17%,'Margin Amount'*10%,'% Margin'>0,Margin Amount'*8%,'% Margin<=0,0)[/TD]
[/TR]
</tbody>[/TABLE]