SusanKVerb
New Member
- Joined
- May 13, 2021
- Messages
- 2
- Office Version
- 2019
- Platform
- Windows
My question is: What is wrong with this formula? It only ever shows what is in I2. The answer is in the J column below.
=IF(AND(I2>=E2,I2<=E2),E2,I2)
I want Cell J2 show E2 … $615
This is correct
Thank you.
=IF(AND(I2>=E2,I2<=E2),E2,I2)
A1 | B1 | C1 | D1 | E1 | F1 | G1 | H1 | I1 | J1 |
Belmont (L) | Mr Jones | $47 | | $615 | $28 | | $690 | $650 | $650 |
A1 | B1 | C1 | D1 | E1 | F1 | G1 | H1 | I1 | J1 |
Belmont (L) | Mr Jones | $47 | | $615 | $28 | | $690 | $600 | $600 |
Thank you.