I have two small tables where I need to compare percentages in columns E, F, G to the values/ranges in A, B, C.
Is there an easier way to do this than the long formula I have started to build?
(file attached)
The yellow formula in cell [I2] is below, which has the following checks:
- IF...
