ExcelBanter - quadrant recognition

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - quadrant recognition (https://www.excelbanter.com/excel-discussion-misc-queries/159039-quadrant-recognition.html)

Aleksandr

quadrant recognition

Can excel regcognize number of quadrant by coordinates x and y

Gary''s Student

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

All times are GMT +1. The time now is 07:59 PM.