Excel 2007 : In need of a formula to check values are even or odd based on other cell

Hey Guys,

Thanks for the replies.

I warned you that my brain cells were misfiring.

I should have been more clear in my explanations.

The user enters values in E21 and in N19.

The value in E21 represents feet above MSL (mean sea level).
The value in N19 represents degrees of the compass, 0-359.

What i need is a check to ensure that;

First of all, the value entered in E21 is between 3,000ft and 18,000ft (forgot to mention the 18,000ft before)

if so then:

(1) if N19 is a value of 0 through 179, E21 must be any odd thousand foot MSL + 500 feet (such as 3,500, 5,500, or 7,500); or

(2) if N19 is a value of 180 through 359, E21 must be any even thousand foot MSL + 500 feet (such as 4,500, 6,500, or 8,500).

I hope that this better explains what I am looking for.

Again, thanks in advance.


George

Thanks for the replies.

While getting ready to reply to Pepe with what follows at the bottom I noticed abousetta's reply.

Thanks abousetta!

Just modified your code a bit to:

=OR(AND(N19<180,ISODD(LEFT(E21,1))),AND(N19>=180,ISEVEN(LEFT(E21,1))))

This works for me!

Thanks.

George


I guess I still haven't explained myself clearly. My apologies.


I would like to make sure that the user has entered the correct VFR cruising altitude per FAA Sec. 91.159
So if he is between 3000ft and 18000ft and heading eastward his flight level must be an odd alt, and vise versa.

I just want to make sure that the user inputs the correct altitude for the direction he will be traveling (VFR).

Since I'm more experienced in using javascript than in excel, I came up with this quick little js program. It does what I need, but coding this for excel is what I cannot seem to do.

   var str = e21;
   str = str.substring(0,1);             // substring(0,1) is like excel's LEFT(e21,1)
    if(e21 > 3000 && e21 < 18000)        // && means AND
    {
        if(n19 < 180 && str %2 == 0)     // %2 means divisble with no remainder
        {
          a="Bearing is Eastward. Altitude must be ODD"
        }           
                    
        if(n19 > 180 && str %2 != 0)
        {
           a="Bearing is Westward. Altitude must be EVEN"
        }
    }

George