=A1*MIN(B1:F1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

wrote in message ...
|I have 5 different columns on my spreadsheet with different prices. I
| want Excel to find the lowest price within those cells and multiply it
| by another price I have designated. How do I do this?