=AND(OR($C100,$D100,$L$70),$C10<1000*Gr6or8,$D1 0<1000*Gr6or8)
The above formula is used validate checkpoints of a given route.
Cell $C10 is the first 3 didgits of the six digit Grid Reference
Cell $D10 is the second set of 3 digits
Cell $L$7 is the Start elevation
Is there any other way to write this and simplify it, when I type it in
my spreedsheet I get this #NAME?
Could you help please.
I did not write the formula merely trying to understand it.
--
Stphn
------------------------------------------------------------------------
Stphn's Profile:
http://www.excelforum.com/member.php...o&userid=20263
View this thread:
http://www.excelforum.com/showthread...hreadid=384314