Hello, I am new to the world of Pivot Tables but am becoming a believer! I am attempting to create a formula via an IF statement but am having a bit of trouble arranging it. What I want to do is the following:
If the value in column ‘AA’ is less than 4100 then return a value of ‘S’, If the value in column ‘AA’ is greater than 4100 but less than 8100 then return a value of ‘M’, If the value in column ‘AA’ is greater than 8100 then return a value of ‘L’.
I want the entire verbiage to be a single formula. Any ideas?