blank cells

  • Thread starter Thread starter pytelium
  • Start date Start date
P

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
 
pytelium wrote...
....
If x1 > w1 print greater, if x1=w1 print equal,if x1< w1 print less,if
x1 is blank,print blank.
Click to expand...
....

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