Autocalculate value in adyacent column

[djzabala]

Hello to everyone, and thanx to those who have supported me so far.

In this case I have another situation here.

I have 2 columns, in column 'A' I have some values, and in column 'B
the values displayed are the results of a formula that involves value
from column 'A'. say, =A1/10 and so on, until the last value in colum
'A'.

BUT, if the range of the column 'A' changes, is there a way that th
'B' column adjust itself adding more rows (with the formula) i
necessary (or calculating only he values presented in 'A', if it's les
rows)??????

I will attach a simple file to describe better what I'm trying to do.
I'm looking forward to apply this to a l-a-r-g-e amount of data, tha
varies in column size, each time it's updated.

Maybe it's easier than I think. but I'm a bit blocked. i wouldn't ge
to do it..

Attachment filename: testfiledj.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=66221

 

[Biff]

Hi!

You can just copy the formula down col B as far as you'd
like. If there are no values in the corresponding row of
col A then the formula in col B will return zero. You can
suppress the display of the zeros a couple of ways:

1. Change your formula to test for empty cells in col A:
=IF(A1="","",A1/10)
=IF(ISBLANK(A1),"",A1/10)

These formulas test A1 and if empty, will leave cell
B1 "blank".

2. Goto Tools>Options>View tab. In Window options,
uncheck: Zero values

Schlumberger, is that the petroleum services company?

Biff