View Single Post
  #1   Report Post  
Stphn
 
Posts: n/a
Default Self Calculating routecard


=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