Purplethunder
New Member
- Joined
- Feb 8, 2019
- Messages
- 2
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
<tbody>
</tbody>
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
Bonus | =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%))))) |
<tbody>
</tbody>