Self Calculating routecard

=AND(OR($C10>0,$D10>0,$L$7>0),$C10<1000*Gr6or8,$D10<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.

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" <[email protected]> wrote in
message news:[email protected]...
>
> =AND(OR($C10>0,$D10>0,$L$7>0),$C10<1000*Gr6or8,$D10<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

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>