Forum Discussion
Solved
Classifying vehicles by weight and class number
Hi there, I have been working on this for a minute and know there must be an easier way to complete the function. I want to compare two columns in excel with the class number, and weight lim...
you need to separate the conditional parts and "=>" is wrong, not to mention it was pointing the wrong way:
=if(and(lower limit<=weight limit, weight limit<=higher limit), "X", "")
similar but alternatively
=if((lower limit<=weight limit)*(weight limit<=higher limit), "X", "")
or
=if(median(lower limit, weight limit, higher limit)=weight limit, "X", "")
you need to separate the conditional parts and "=>" is wrong, not to mention it was pointing the wrong way:
=if(and(lower limit<=weight limit, weight limit<=higher limit), "X", "")
similar but alternatively
=if((lower limit<=weight limit)*(weight limit<=higher limit), "X", "")
or
=if(median(lower limit, weight limit, higher limit)=weight limit, "X", "")