Self Calculating routecard

S

Stphn

=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.
 
B

Bob Phillips

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?
 
B

Bob Phillips

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