Repeat Cell Based on the Value-Excel 2003

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.
 
S

Stefi

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:
 
S

Stefi

You are welcome! Thanks for the feedback!

Clicking the YES button will be appreciated.
Stefi

„Elaine†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top