Formula configurations

  • Thread starter Thread starter Bill Clifford
  • Start date Start date
B

Bill Clifford

I would like to find a means of applying a formula to each
row of a file without having to manually key in each row
number, i.e. add C2+G2, and calculate a percentage, and an
average. Each row would need these same operations
performed. Then, at the end, I would like to do the same
operations for the total values. But, as new records are
added, is there a way to have the row number default to
the current last row?
 
Hi Bill
not quite sure that this is what you want but try
1. In row 2 (e.g. in H2) enter the following formula:
=IF(AND(G2<>"",C2<>""),G2+C2,"")
and copy this formula down as far as you need it (the row index will
change automatically)

2. To get the total the easiest way would be to use a cell at the top
for summing (lets say you use row in, that is H1 for this). Try the
following formula in H1:
=SUM(C:C)+SUM(G:G)
 
Frank,
Item 1. The row index does not change. Thus, each row had
the same result. Specifically, I want col. G subtracted
from col. C with the answer in col. H. Then, col. I is
col. H divided by col. F. And, col. J is col. H divided by
col. C.
Simple, right?
Item 2. I keep getting a 0.
Thanks for your help.
Bill Clifford
 
Hi Bill
1. the formulas should update if you copy them down. That is insert the
following formula in H2
=IF(AND(G2<>"",C2<>""),C2-G2,"")
dow move the mouse to the lower right corner of this cell (H2) and drag
down. The row numbers will change

2. In I2 enter
=IF(AND(F2<>"",F2<>0,H2<>""),H2/F2,"")
and copy/drag down

3. In J2 enter
=IF(AND(C2<>"",C2<>0,H2<>""),H2/C2,"")

The sum formulas also should produce a value. You may check that
automatic calculation is enabled (goto 'Tools - Options - calculation'
and check 'automatic calculation')
 
Frank,
You're a genius!! Works great! Where does one go to find
this information? Or, does it come with genius?
Thanks, again.
Bill Clifford
 
Hi Bill
thanks for the feedback :-)
How to gather this information: Try staing in this NG and learn by
'lurking' :-)
 
Back
Top