Hi, I would appreciate help in copying a formula across a row that includes
the previous cells results. For example, assuming that the formula in cell
A30 is, +A22*A50, cell B30 would be +B22*$A$50+A30, and cell C30, it would be
+C22*$A$50 +$A$30+B30, I would like to do this for 25+ cells and am sure that
there must be an easier way to replicate this formula.
Thanks, Bob

In A30 start with:

=A22*A50

Then in B30, enter this formula:

=$A$50*INDEX(22:22,COLUMNS($A:B))+SUM($A$30:A30)

And copy across as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Boblink" wrote in message
...
Hi, I would appreciate help in copying a formula across a row that
includes
the previous cells results. For example, assuming that the formula in cell
A30 is, +A22*A50, cell B30 would be +B22*$A$50+A30, and cell C30, it would
be
+C22*$A$50 +$A$30+B30, I would like to do this for 25+ cells and am sure
that
there must be an easier way to replicate this formula.
Thanks, Bob

Hi

Try in A30
=A$22*$A$50
In B30
=B$22*$A$50+SUM($A$22:A$22)
Copy across as required
--
Regards
Roger Govier

"Boblink" wrote in message
...
Hi, I would appreciate help in copying a formula across a row that
includes
the previous cells results. For example, assuming that the formula in cell
A30 is, +A22*A50, cell B30 would be +B22*$A$50+A30, and cell C30, it would
be
+C22*$A$50 +$A$30+B30, I would like to do this for 25+ cells and am sure
that
there must be an easier way to replicate this formula.
Thanks, Bob

I kinda overcomplicated it ... didn't I?<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

Try in A30
=A$22*$A$50
In B30
=B$22*$A$50+SUM($A$22:A$22)
Copy across as required
--
Regards
Roger Govier

"Boblink" wrote in message
...
Hi, I would appreciate help in copying a formula across a row that
includes
the previous cells results. For example, assuming that the formula in
cell
A30 is, +A22*A50, cell B30 would be +B22*$A$50+A30, and cell C30, it
would be
+C22*$A$50 +$A$30+B30, I would like to do this for 25+ cells and am sure
that
there must be an easier way to replicate this formula.
Thanks, Bob

It happens - usually to me<bg

--
Regards
Roger Govier

"RagDyer" wrote in message
...
I kinda overcomplicated it ... didn't I?<bg
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

Try in A30
=A$22*$A$50
In B30
=B$22*$A$50+SUM($A$22:A$22)
Copy across as required
--
Regards
Roger Govier

"Boblink" wrote in message
...
Hi, I would appreciate help in copying a formula across a row that
includes
the previous cells results. For example, assuming that the formula in
cell
A30 is, +A22*A50, cell B30 would be +B22*$A$50+A30, and cell C30, it
would be
+C22*$A$50 +$A$30+B30, I would like to do this for 25+ cells and am sure
that
there must be an easier way to replicate this formula.
Thanks, Bob

Thank you for your help RD and Roger, I used the simpler solution but as they
say, in the land of the blind, the one eye giant is king and the
"complicated" solution obvious was MUCH simpler than my approach,so thank you
for your help guys.

If either of you are up to it, I am playing around with an "IF" calculation
that I am having all sorts of trouble with.

Actually, there are 4 different "Ifs" with the following criteria:

* Cells 11, 13, 25 and 31 contain positive numbers.
* Cells 11, 13 and 25 can NOT be negative, cell 31 CAN be negative
* Cell 37 should be subtracted from each of these cells individually in the
following sequence:
- The first calculation is, cell 37 subtracted from cell 11
- Once cell 11 is negative, cell 37 should be subtracted from cell 13
- Once cell 13 is negative, cell 37 should be subtracted from cell 25
- Once cell 25 is negative, cell 37 should be subtracted from cell 31
- If cell 31 is negative, cell 31 CAN contain a negative (if cell <37 less
cell 31 is negative, the negative number should appear in cell 31)
* Cells 11, 13 and 25 can not be negative; they can only contain a positive
number.
*If the results of the calculations are negative (that is cell 37 is greater
than the one of these cells), a €œzero€� should be entered into this cell and
the negative results should be brought forward to the next cell.

Example:
if B37 less B11 is positive, the positive number should appears in cell 11.
If C37 less C11 is negative, a €œzero€� should be entered for cell C11 and
the negative results be carried to the next cell in the sequence, C13.
The calculations for C13 would be (C37 less C13) less (C37 less C11).
The calculations for the €œD€� cells would be:
- Cell D11 is €œzero€�
- D13 would be the results of (D37 less D13)
This continues until (D37 less D13) is a negative number
When D13 becomes negative, a €œzero€� should be entered in cell D13 and the
negative results brought to cell D25 (as was done when cell 11 became
negative)
Cells 11 and 13 would be €œzero€� and the calculations (cell 37 less cell 25)
continue until cell 25 is negative.
Once cell 25 becomes negative, the process is repeated for cell 31
If (cell 37- cell 31) results in a negative number, the NEGATIVE number
SHOULD be displayed in cell 31.
Cell 31 CAN display BOTH positive and negative numbers.

Again, thank you for saving me all the time I would have spent with my
myopic approach, =B$22*$A$50+SUM($A$22:A$22) worked just great.
If you can help with the "Ifs", I would appreciate it, if not, I can
understand that there are bigger, better,.... fish to fry.
Thank you again,
Bob

Hi Bob

If I understand the problem correctly, then in cell C11
=MAX(0,B11-B37)
in cell C13
=IF(C110,B13,MAX(0,(B11+B13)-B37))
in cell C25
=IF(C130,B25,MAX(0,(B11+B13+B25)-B$37))
in cell C31
=IF(C250,B31,(B11+B13+B25+B31)-B37)

--
Regards
Roger Govier

"Boblink" wrote in message
...
Thank you for your help RD and Roger, I used the simpler solution but as
they
say, in the land of the blind, the one eye giant is king and the
"complicated" solution obvious was MUCH simpler than my approach,so thank
you
for your help guys.

If either of you are up to it, I am playing around with an "IF"
calculation
that I am having all sorts of trouble with.

Actually, there are 4 different "Ifs" with the following criteria:

* Cells 11, 13, 25 and 31 contain positive numbers.
* Cells 11, 13 and 25 can NOT be negative, cell 31 CAN be negative
* Cell 37 should be subtracted from each of these cells individually in
the
following sequence:
- The first calculation is, cell 37 subtracted from cell 11
- Once cell 11 is negative, cell 37 should be subtracted from cell 13
- Once cell 13 is negative, cell 37 should be subtracted from cell 25
- Once cell 25 is negative, cell 37 should be subtracted from cell 31
- If cell 31 is negative, cell 31 CAN contain a negative (if cell <37 less
cell 31 is negative, the negative number should appear in cell 31)
* Cells 11, 13 and 25 can not be negative; they can only contain a
positive
number.
*If the results of the calculations are negative (that is cell 37 is
greater
than the one of these cells), a €œzero€� should be entered into this cell
and
the negative results should be brought forward to the next cell.

Example:
if B37 less B11 is positive, the positive number should appears in cell
11.
If C37 less C11 is negative, a €œzero€� should be entered for cell C11 and
the negative results be carried to the next cell in the sequence, C13.
The calculations for C13 would be (C37 less C13) less (C37 less C11).
The calculations for the €œD€� cells would be:
- Cell D11 is €œzero€�
- D13 would be the results of (D37 less D13)
This continues until (D37 less D13) is a negative number
When D13 becomes negative, a €œzero€� should be entered in cell D13 and the
negative results brought to cell D25 (as was done when cell 11 became
negative)
Cells 11 and 13 would be €œzero€� and the calculations (cell 37 less cell
25)
continue until cell 25 is negative.
Once cell 25 becomes negative, the process is repeated for cell 31
If (cell 37- cell 31) results in a negative number, the NEGATIVE number
SHOULD be displayed in cell 31.
Cell 31 CAN display BOTH positive and negative numbers.

Again, thank you for saving me all the time I would have spent with my
myopic approach, =B$22*$A$50+SUM($A$22:A$22) worked just great.
If you can help with the "Ifs", I would appreciate it, if not, I can
understand that there are bigger, better,.... fish to fry.
Thank you again,
Bob