ypatel1990
New Member
- Joined
- Aug 8, 2014
- Messages
- 11
Hey everyone,
I currently have a column with a list of percentages of year over year change and am trying to create a column next to it to show different groupings that it would fall under for a pivot table. I keep getting the value false when running my if statements. I have an example of what I am trying to do in the Grouping column below. Not sure if the numbers being percentages is causing problems but I tried to copy and paste the column as values but all of the numbers changed.
<TBODY>
</TBODY>
I currently have a column with a list of percentages of year over year change and am trying to create a column next to it to show different groupings that it would fall under for a pivot table. I keep getting the value false when running my if statements. I have an example of what I am trying to do in the Grouping column below. Not sure if the numbers being percentages is causing problems but I tried to copy and paste the column as values but all of the numbers changed.
YOY | Grouping |
0.0% | 0 |
-25.7% | -49 to -1 |
800% | 100+ |
-80.3% | -100 to -50 |
52% | 50 to 100 |
<TBODY>
</TBODY>