View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
[email protected] vjohns158@gmail.com is offline
external usenet poster
 
Posts: 6
Default 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!