E
evoxfan
Below is the formula I currently have. I want to get a "1" if the logical
test answer returns a number not equal to 2-16 (a range). So if the number is
less than 2 or greater than 16, I need a 1, otherwise I need "Assign
Division".
How do you put "not equal" in a formula and how do you put "not equal" to a
range of numbers?
=IF(MID(D26,2,2)<2>16,1,"Assign Division")
Thanks in advance for your help.
test answer returns a number not equal to 2-16 (a range). So if the number is
less than 2 or greater than 16, I need a 1, otherwise I need "Assign
Division".
How do you put "not equal" in a formula and how do you put "not equal" to a
range of numbers?
=IF(MID(D26,2,2)<2>16,1,"Assign Division")
Thanks in advance for your help.