This content has been marked as final. Show 1 reply
I have a pivot table that is set up like this:
amount 1 amount 2 %
1699.53 323.53 Column2/column1 or 19%
I need help with an expression that says if column 3 is 60%> or larger then i want 2% of column 2. If it is 51-60% then i want 1.5%. if it is 45-50% then i want 1%.
Any suggestions? I am befuzzled on this one.