Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Length Calculation
I have a column of 20 cells that have IF statements in them. The if
statement is such: =(IF('A-V Input'!C5=0,0,IF(('A-V Input'!C4-'A-V Input'!C5)/120,('A-V Input'!C4-'A-V Input'!C5)/12,(('A-V Input'!C4-'A-V Input'!C5)/12)*-1)))+(IF('A-V Input'!D5=0,0,IF(('A-V Input'!D4-'A-V Input'!D5)/120,('A-V Input'!D4-'A-V Input'!D5)/12,(('A-V Input'!D4-'A-V Input'!D5)/12)*-1))) I use it to calculate distance from points in a X,Y corridinate system from AutoCAD. What I need to know is how to check if the cell above the last cell has a distance in it if it doesn't move to the next cell above the previous cell to check it etc... when it encounters a cell that has a number in it, the cell would calculate the distance back to the origin. I could write a another IF statement but I think it would be to long. any help would be greatly welcomed Lee |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Commission Calculation with IF Stmt. | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |