IF [ Fee Range] > 10000000 THEN "$10M or more"
And IF 2000000>[Fee Range]>1000000 THEN "1M-2M"
AND IF [Fee Range]<500000 THEN "<500K"
AND IF 5000000>[Fee Range]>1000000 THEN "2M-5M"
AND IF 500000>[Fee Range]>1000000 THEN "500K-1M" else "NO Fee" endif
I need all these conditions on a column that looks like
| Fee |
| 1114330 |
| 381845 |
| 3087145 |
| 2719749 |
| 2637217 |
| 5886258 |
| 1507268 |
| 2066201 |
| 3911559 |
| 1239760 |
| 4655452 |
| 15691919 |
| 7087729 |
| 1711112 |
| 5539455 |
| 7812067 |
| 3279808 |
| 2964199 |
| 11732179 |
| 4554204 |
| 2492555 |
and the results should look like :
| 1114330 | $1M to <$2M |
| 381845 | <$500K |
| 3087145 | $2M to <$5M |
| 2719749 | $2M to <$5M |
| 2637217 | $2M to <$5M |
| 5886258 | $5M to <$10M |
| 1507268 | $1M to <$2M |
| 2066201 | $2M to <$5M |
Any help is highly appreciated.
