Hello,
I hope you are well! Would you please help me?
I would like to program the following logic into a cell:
If cell B10 is less than 100, result is "1".
If cell B10 is greater than 100 but less than or equal to 380, result is "2".
If cell B10 is greater than 380 but less than or equal to 1500, result is "4".
If cell B10 if greater than 1500, result is "ERROR".
Is this possible to do in a single cell? Thanks!
I hope you are well! Would you please help me?
I would like to program the following logic into a cell:
If cell B10 is less than 100, result is "1".
If cell B10 is greater than 100 but less than or equal to 380, result is "2".
If cell B10 is greater than 380 but less than or equal to 1500, result is "4".
If cell B10 if greater than 1500, result is "ERROR".
Is this possible to do in a single cell? Thanks!