Thread: quadrant recognition
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default quadrant recognition
Sure. If x is in A1 and y is in B1 then:

=(A10)*((B10)+(B1<0)*2)+(A1<0)*((B10)*4+(B1<0)* 3)

--
Gary''s Student - gsnu200745


"Aleksandr" wrote:

Can excel regcognize number of quadrant by coordinates x and y
Reply With QuoteReply With Quote