Dear Participants,
How can I multiply four cells by one cell, giving separate 4 outcomes for example:
cells : E3:E6 should be multiplied by B1 and outcome saved in F3:F6 respectively.
I cant use dollar sign as for next sequences multiplier-cell will change too... i.e. for E7:E10 we multiply B2 saving results again F7:F10 respectively,
E11:14 we multiply B3, and so on...
I will wait for your suggestions ,I have attached the xlsx file here and highlighted the cells 🙂
Sardor
Hi Sardor,
In your workbook there is nothing in B1 or B2?
The rest of ColB contains text, so you can't multiply that by anything.
You could have the same number B1:B4, then the next 4 cells B5:B8 contain the same number etc. Then your formula in ColF for multiplying the values in ColB by the values in ColE is much easier.
Regards
Phil
As Phil said, your workbook doesn't seem to match your requirement, but you can multiply by:
INDEX(B:B,INT((ROW()-3)/4)+1)
which will use B1 for rows 3:6, B2 for rows 7:10 and so on.
