rjwalker2514
New Member
- Joined
- Aug 4, 2018
- Messages
- 7
HEIGHT | 2000 |
WIDTH | 2100 |
TOTAL SIZE | 4100 |
DESIGN | 1 |
Out of Range |
<tbody>
</tbody>
Hi I would like a function that will detect if a value is outside the design parameters.
Example:
DESIGN 1 is only compatible if the total size is between 1000 & 4000 inclusive. How can I write a formula that detects that this example if Out of Range and shows that in a nearby cell?
If the DESIGN number was to change to 2 the compatible size would now be between 1000 & 2600. Can I add to the formula to show this also?