IF-AND command
I have a numerical value in cell B1
If value in B1 < = 5 then display “8SWG”
If value in B1 > 5 but < 16 then display “12SWG”
If value in B1 >= 16 but < =150 then display “25x3mm”
If value in B1 >150 but < =200 then display “40x6mm”
If value in B1> =200 then display “50x6mm”
I tried with IF-AND, but it is returning the error “too many arguments”. Is there a command to do this?
Bookmarks