Self Calculating routecard

  • Thread starter Thread starter Stphn
  • Start date Start date
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.
 
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?
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"IF" formula help needed 4
Automatisation - Operations on a table on one line 3
Help needed with a formula or macro 1
Getting rid of error messages while using IF statements 4
PMT calculator 8
i need more help with this time question 5
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
Calculating on multiple variables 1

Back
Top