fortune
New member
A6:L6 generates either 1 or 0 with a rule that ONLY 1 of the cell in the range (A6:L6) would be equal to 1.
A2:L2 also generates values.
I want to use the corresponding cell in the range A2:L2 for 1 generated in the A6:L6 for comparison with N2.
N2 also generates a value.
Output required: O2=If N2>=(cell from the range A2:L2) than 1000 else 2000.
How to accomplish.
Thanks
Sheet1
A2:L2 also generates values.
I want to use the corresponding cell in the range A2:L2 for 1 generated in the A6:L6 for comparison with N2.
N2 also generates a value.
Output required: O2=If N2>=(cell from the range A2:L2) than 1000 else 2000.
How to accomplish.
Thanks
Sheet1
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
1 | Compare with | Result | |||||||||||||
2 | 200 | 450 | 250 | 150 | 175 | 200 | 400 | 100 | 200 | 500 | 555 | 185 | 200 | 2000 | |
3 | |||||||||||||||
4 | |||||||||||||||
5 | |||||||||||||||
6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |