Calculation based on lowest price
On Dec 11, 4:25 pm, "Niek Otten" wrote:
=A1*MIN(B1:F1)
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
wrote in ...
|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?
Thank you so much!
|