G
Guest
Guest
Trying to build a simple if/then statement measuring ranges. For example:
Cell A1 is greater than 50 but less than 100.
Cell A2 is greater than 100 but less than 500.
I need an if/then statement to say: if A1 is between 50 and 100,then "TRUE", else "false".
Cell A1 is greater than 50 but less than 100.
Cell A2 is greater than 100 but less than 500.
I need an if/then statement to say: if A1 is between 50 and 100,then "TRUE", else "false".