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

Lee
Take a step back and read what you wrote. Now imagine someone walking
in off the street (he doesn't know anything about what you are doing) and
reading what you wrote. That guy is us.
Reword your post and aim it at someone who has no knowledge at all about
what you are doing or what you want. You will get plenty of help. HTH
Otto
"Lee" wrote in message
...
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