Hi, I have a spreadsheet with several hundred rows and multiple columns.
Each column has a multiplier value. Each row has numbers in some of the
columns. I need a formula that wil tell me what the maximum product would be
for each row of all the column multipliers and numbers.

eg. The multipliers are in Row 1 and the data table is B3:F6. The
resulting max product for each row is shown in column A.

A B C D E F
1 Multiplier 80 40 20 10 5
2 MAX PROD
3 40 0 1 1 0 0
4 160 2 1 1 1 1
5 100 1 1 5 1 10
6 100 1 1 1 1 20

I know the following would work and could be copied down for each row, but
it will become a very long formula with more colums:
=MAX(B$1*B3,C$1*C3,D$1*D3,E$1*E3,F$1*F3)
Could this formula be reworked to use an array, or is there another formula
that would be better?

Thanks,
Ryan