Hi Team,
I am looking excel formula to compare two columns value (with Column A Value)
Column A value should be greater than Column B and C cells value
Below is a table with expected output is in Column D.
Thanks
mg
I am looking excel formula to compare two columns value (with Column A Value)
Column A value should be greater than Column B and C cells value
Below is a table with expected output is in Column D.
Book1 | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Amt | bonus | commission | Status | My attempted | ||
2 | 500 | 600 | 800 | FALSE | TRUE | ||
3 | 500 | 600 | 400 | FALSE | TRUE | ||
4 | 500 | 200 | 700 | FALSE | TRUE | ||
5 | 500 | 300 | 200 | TRUE | TRUE | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
E2:E5 | E2 | =A2>B2>C2 |
Thanks
mg