Calculation based on lowest price

[vjohns158]

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?

 

[Niek Otten]

=A1*MIN(B1:F1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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?

 

[Bob Phillips]

=MIN(rng)*other_value

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[T. Valko]

Try this:

=A1*MIN(B1:F1)

 

[vjohns158]

=MIN(rng)*other_value

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)






- Show quoted text -

Thanks a ton, I just figured this out!

 

[vjohns158]

=A1*MIN(B1:F1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|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!

 

[Conan Kelly]

vjohns158,

Use the MIN() function:

=MIN(Range)

Using your exmple:

=MIN(A2:A50)*2.50