Hello! I’m trying to create an if function with 9 combinations. So if the selected cell equals 2 3/8, its 6.99, if its 2 7/8, its 9.67 and so on.
| A | B |
|---|---|
| 2 3/8 | 6.99 |
| 2 7/8 | 9.67 |
| 3 1/2 | 13.84 |
| 4 1/2 | 17.26 |
| 5 1/2 | 23.07 |
| 7 LW | 29.76 |
| 7 HW | 34.23 |
| 8 5/8 | 35.72 |
| 9 5/8 | 48.07 |
