Hi there,
I'm trying to write a formula to express measured values as compass quadrants using the IF Function. I've managed to express the first two although I can't get the function to express any more than two. So far I've got:
=IF(AND(J2>22.5,J2<67.5),("NE"),IF(AND(J2>67.5,J2<112.5),("E")))
This returns any values between 22.5 to 67.5 as NE, between 67.5 - 112.5 as E and and all others as FALSE. Adding any further parameters ruins the formula. Is there a maximum number of values you can express using the IF and AND formulas, or is there another way or creating this formula?
There parameters I would like to set are
22.5 - 67.5 = NE
67.5 - 112.5 = E
112.5 - 157.5 = SE
157.5 - 202.5 = S
202.5 - 247.5 = SW
247.5 - 292.5 = W
292.5 - 337.5 = NW
337.5 - 22.5 = N
Any help would be much appreciated.
Iain
Bookmarks