Good Afternoon,
I am looking for help in creating a formula. I have tried multiple if, ifs and statements and cannot get the desired result.
I would like the result to populate in Column G. (The result would be 1,2,3,4 or ,5)
I need help in putting this as one formula in G2. The result in G2 would be 3
If B2<C2, 1
If B2<D2, 2
IF B2<E2, 3
If B2<F2,4
If B2>=F2,5
I am looking for help in creating a formula. I have tried multiple if, ifs and statements and cannot get the desired result.
I would like the result to populate in Column G. (The result would be 1,2,3,4 or ,5)
I need help in putting this as one formula in G2. The result in G2 would be 3
If B2<C2, 1
If B2<D2, 2
IF B2<E2, 3
If B2<F2,4
If B2>=F2,5
A | B | C | D | E | F | G |
Name | Rate | 10th | 33.33rd | 66.67th | 90th | Result |
Getting care easily | 0.877 | 0.825 | 0.868 | 0.900 | 0.924 | |