Johnboy28
Board Regular
- Joined
- Jun 22, 2013
- Messages
- 172
- Office Version
- 365
- 2019
- 2016
- 2013
- 2010
- Platform
- Windows
Hi, does anyone now if there is another IFS formula or something simular that works with excel 2013 or earlier. The below formula only works with the later versions.
Thank you
<tbody>
</tbody>
Thank you
A | B | C | D | E | F | G |
2 | ||||||
3 | < 1 MNTH | 1-3 MNTH | 3-6 MNTH | 6-9 MNTH | 9-12 MNTH | 1 YR > |
4 | ||||||
5 | Range 1 | Range List | ||||
6 | 1.51 | #NAME? | ||||
7 | 1.51 | #NAME? | ||||
8 | 1.48 | #NAME? | ||||
9 | 1.45 | #NAME? | ||||
10 | 1.41 | #NAME? | ||||
11 | 1.31 | #NAME? | ||||
12 | 1.28 | #NAME? | ||||
13 | 1.51 | #NAME? | ||||
14 | 1.51 | #NAME? | ||||
=ifs(B6<1,$B$3,B6<3,$C$3,B6<6,$D$3,B6<9,$E$3,B6<12,$F$3,B6>12,$G$3) | ||||||
<tbody>
</tbody>