datastudent
New Member
- Joined
- Sep 7, 2021
- Messages
- 49
- Office Version
- 365
- Platform
- Windows
Hi,
I want to remove this "more than 90 days" in my Tenurity column when the Promotion is blank or 0.
The result I want to show:
less than 90 days
90 days
more than 90 days
blank(if no promotion #)
Here's the formula I tried so far.
=IF(@Q:Q<=89,"less than 90 days",IF(@Q:Q=90,"90 days",IF(@Q:Q>=91,"more than 90 days",IF(ISBLANK(@Q:Q),""))))
=IF(@Q:Q<=89,"less than 90 days",IF(@Q:Q=90,"90 days",IF(@Q:Q>=91,"more than 90 days",IF(@Q:Q=0,"external"))))
I want to remove this "more than 90 days" in my Tenurity column when the Promotion is blank or 0.
The result I want to show:
less than 90 days
90 days
more than 90 days
blank(if no promotion #)
Here's the formula I tried so far.
=IF(@Q:Q<=89,"less than 90 days",IF(@Q:Q=90,"90 days",IF(@Q:Q>=91,"more than 90 days",IF(ISBLANK(@Q:Q),""))))
=IF(@Q:Q<=89,"less than 90 days",IF(@Q:Q=90,"90 days",IF(@Q:Q>=91,"more than 90 days",IF(@Q:Q=0,"external"))))