length Calcs
 

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

length Calcs
 

Try using the "Is" function, look in msexcel help

If (IsNumeric(cell(1,1).value),...

"Lee" wrote:

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