Repeat Cell Based on the Value-Excel 2003

  • Thread starter Thread starter Elaine
  • Start date Start date
E

Elaine

Hello,

I want to repeat a formula based on the value in another cell.
Example:
Formula/Result located in Cell B8
Value 5 located in Cell A2

How do I repeat the formula in cell B8 based on the value in cell A2? In
this example, the end result would have the formula in cell B8 repeated in
cells B9, B10, B11, B12, & B13. The number in cell A2 varies.
 
You have to use a macro if you want a cell to fill with a formula or left
blank depending on a condition. If you don't want to use a macro, you can
make a workaround like this:

Enter this formula in B9
=IF($A$2-(ROW()-9)>0,formulainB8,"")
and fill it down through as many rows as the maximum value of A2.

Regards,
Stefi

„Elaine†ezt írta:
 
You are welcome! Thanks for the feedback!

Clicking the YES button will be appreciated.
Stefi

„Elaine†ezt írta:
 
Back
Top