kradclayton
New Member
- Joined
- Oct 2, 2020
- Messages
- 11
- Office Version
- 365
- Platform
- Windows
Hi All,
I need help on a multiple tiered IF function.
I have a current IF formula - =IF(I2<5,5,CEILING(I2/3,10)) however I now need to add another criteria to the formula to look at disregarding this formula if the minimum of date created is newer than 01/01/2021, in which case id like it to return a 10.
here's the below columns I'm using:
Minimum of fdate created = H
Count of Samples purchase LTM = I
I need help on a multiple tiered IF function.
I have a current IF formula - =IF(I2<5,5,CEILING(I2/3,10)) however I now need to add another criteria to the formula to look at disregarding this formula if the minimum of date created is newer than 01/01/2021, in which case id like it to return a 10.
here's the below columns I'm using:
Minimum of fdate created = H
Count of Samples purchase LTM = I
Minimum of Date Created | Count of Samples purchase LTM |
11-Jul-16 | 350 |
28-Jul-16 | 321 |
11-Jul-16 | 318 |