| 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 |
| 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) | |||
Threaded Mode
