quadrant recognition

  • Thread starter Thread starter Guest
  • Start date Start date
Sure. If x is in A1 and y is in B1 then:

=(A1>0)*((B1>0)+(B1<0)*2)+(A1<0)*((B1>0)*4+(B1<0)*3)
 
Back
Top