• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Validation in Excel 2007

iswar10

New Member
Your tips are really something to be appreciated!

I have a problem!!

I feel you are the guy for it!!!


I am trying to do a nautical problem using Excel 2007.

How would I allow user to input degrees and minutes in adjacent (on in different) cells?

Since Latitude is not more than 90°, if the user input 90° in the degrees cell, then the minutes cell must go blank (or not to allow other than 0)

If the user in put any integer between 0 and 59, allow the user to input between 0’ and 60.0’ in the minutes cell.

I validate the degree cell easily i.e. any integer between 0 and 90.

I have a problem in validating the minute cell. It needs a conditional validation, I feel, so the two cells together will give a result between 00° 00.0’ and 90° 00.0’.

Please help! Thanks!!
 
Hi,


These two posts may help:


http://chandoo.org/wp/2008/11/25/advanced-data-validation-techniques-in-excel-spreadcheats/


http://www.contextures.com/xlDataVal02.html#TwoWord
 
Back
Top