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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there an Excel magic quadrant template 1
Need help making algebra graphs 1
OT: Cartesian Coordinate Quadrant Question. 2
Cartesian Coordinate System 4
How to create 4 Quadrant Chart in Excel 2003? 1
How do I draw a quadrant with coloured regions in Excel? 3
Y axis labels 2
How to get 4 positive quadrants in xy scatter graph 1

Back
Top