Insert output of the formula in a different cell

[Needy]

I have a formulas in cells of row 6 that checks if the same column row 8 has a value above 0. If true I want it to add "x" columns (entered in row 7 of the same column) and enter the result of the formula from row 6 to cell address ( 9, column + "x").
example
formula is in B6
B8 has a value above 0
B7 has 3 (as number of columns to be added )
so column of target cell would be B+3 = E
and Row would be 9
Which is E9
so the result of the formula in B6 will be displayed in E9 and the result of the formula in C6 will be displayed in F9

Any help would be highly appreciated.

[Richard Buttrey]

Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

Show a before and after situation and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

[Needy]

I am sorry here is a display of the section of the sheet and what is expected.Excel putting result of a formula in another Cell.jpg

[Richard Buttrey]

I asked that a workbook be uploaded not a picture - to see why we ask this see the suggestions in the forum rules.

[Needy]

I am new here and dont know how to attach a file.
Lets just delete the post. Thanks.

[Richard Buttrey]

Hi,

Just attach the file as you did your picture. The FAQ indicates how - see http://www.excelforum.com/faq.php?fa...b3_attachments

[Needy]

Attached is the excel file for reference.
Thanks

[ChemistB]

In C10

=SUM(IF(COLUMN()-$B$7:C7-COLUMN($B$7:C7)=0, $B$8:C8*$B$9:C9,0))
entered as an array (CNTRL SHFT ENTER instead of ENTER. You'll see brackets {} around your formula)
Drag formula to the right.
Does that work for you?

[Needy]

Thanks ChemistB
It works like a charm.