I need a formula that checks if a cell number is between two numbers in two other cells AND checks if another cell is between two numbers in two other cells.
IF B10 is >C10 and <D10 AND B11 is >C11 and <D11, "Water is Perfect",""
But I don't know how to write it.
Can you please help?
File attached.
Thanks.
Robert
Bookmarks