| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating hours | Excel Worksheet Functions | |||
| Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
| Calculating total amount of sales for each salesman | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
Linear Mode
