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

The formula doesn't know what Gr6or8 is, nor do we because you haven't said.

How should the calc work
if C10,D10 and L7 are 0
if only two are 0
if only 1 is greater than 0?

--
HTH

Bob Phillips

"Stphn" wrote in
message ...

=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

Thanks for the reply I beleive the Gr6or8 refers to the size of the grid
reference


--
Stphn
------------------------------------------------------------------------
Stphn's Profile: http://www.excelforum.com/member.php...o&userid=20263
View this thread: http://www.excelforum.com/showthread...hreadid=384314

Which means what? The formula doesn't know it, which means Excel doesn't
know it. It needs to be defined.

--
HTH

Bob Phillips

"Stphn" wrote in
message ...

Thanks for the reply I beleive the Gr6or8 refers to the size of the grid
reference


--
Stphn
------------------------------------------------------------------------
Stphn's Profile:
http://www.excelforum.com/member.php...o&userid=20263
View this thread: http://www.excelforum.com/showthread...hreadid=384314