blank cells

[pytelium]

If I have 2 columns say cells w1 to w10 and x1 to x10. In w1 to w1
every cell contains numbers,x1 to x10 contains numbers and blanks.

I want to produce a third column y1 to y10.

If x1 > w1 print greater, if x1=w1 print equal,if x1< w1 print less,i
x1 is blank,print blank.

what formula will I use in the y column

 

[Harlan Grove]

pytelium wrote...
....

If x1 > w1 print greater, if x1=w1 print equal,if x1< w1 print less,if
x1 is blank,print blank.

....

=IF(ISBLANK(X1),"",LOOKUP(SIGN(W1-X1),{-1;0;1},{"greater";"equal";"less"}))

 

[pytelium]

Thank you!