adrienne0914
Board Regular
- Joined
- Mar 22, 2018
- Messages
- 65
- Office Version
- 365
- Platform
- Windows
Hi all,
I'm trying to group data based on volume. I'm grouping as follows:
It looks like this:
<tbody>
</tbody>
My formula is:
=IF(B2>2000,"A",IF(B2>=1000,"B",IF(B2>=500,"C",IF(B2>=100,"D",IF(B2>0,"E", IF(B2=0,"F",IF(D2=0,"F")))))))
I'm trying to weed out the ones with no activity in 2017 or 2018, making them group F. The way my formula reads now, it assigns group F if B or D equal 0. I don't want DEC Company to be F because there was an increase in activity from 2017 to 2018.
I want the formula to assign group F if B AND D equal 0. Not sure how to insert an AND formula.
Thanks in advance!
I'm trying to group data based on volume. I'm grouping as follows:
A: >2000
B: 1000-2000
C: 500-999
D: 100-499
E: 1-99
B: 1000-2000
C: 500-999
D: 100-499
E: 1-99
It looks like this:
Company | FY 2017 | YTD 2017 | YTD 2018 | Group |
ABC Company | 40 | 12 | 12 | E |
DEF Company | 0 | 0 | 0 | F |
GHI Company | 2,489 | 1,136 | 945 | A |
JKL Company | 1,025 | 250 | 485 | B |
VH1 Company | 536 | 169 | 101 | C |
CBS Company | 155 | 75 | 77 | D |
DEC Company | 0 | 0 | 11 | F |
<tbody>
</tbody>
My formula is:
=IF(B2>2000,"A",IF(B2>=1000,"B",IF(B2>=500,"C",IF(B2>=100,"D",IF(B2>0,"E", IF(B2=0,"F",IF(D2=0,"F")))))))
I'm trying to weed out the ones with no activity in 2017 or 2018, making them group F. The way my formula reads now, it assigns group F if B or D equal 0. I don't want DEC Company to be F because there was an increase in activity from 2017 to 2018.
I want the formula to assign group F if B AND D equal 0. Not sure how to insert an AND formula.
Thanks in advance!