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?

=A1*MIN(B1:F1)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

<(E-Mail Removed)> wrote in message news:2f3c41a1-2b1e-49ca-9204-(E-Mail Removed)...
|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?

=MIN(rng)*other_value

--
---
HTH

Bob


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



<(E-Mail Removed)> wrote in message
news:2f3c41a1-2b1e-49ca-9204-(E-Mail Removed)...
>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?

Try this:

=A1*MIN(B1:F1)

--
Biff
Microsoft Excel MVP


<(E-Mail Removed)> wrote in message
news:2f3c41a1-2b1e-49ca-9204-(E-Mail Removed)...
>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?

On Dec 11, 4:26 pm, "Bob Phillips" <bob....@somewhere.com> wrote:
> =MIN(rng)*other_value
>
> --
> ---
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> <vjohns...@gmail.com> wrote in message
>
> news:2f3c41a1-2b1e-49ca-9204-(E-Mail Removed)...
>
>
>
> >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?- Hide quoted text -
>
> - Show quoted text -

Thanks a ton, I just figured this out!

On Dec 11, 4:25 pm, "Niek Otten" <nicol...@xs4all.nl> wrote:
> =A1*MIN(B1:F1)
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> <vjohns...@gmail.com> wrote in messagenews:2f3c41a1-2b1e-49ca-9204-(E-Mail Removed)...
>
> |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!

vjohns158,

Use the MIN() function:

=MIN(Range)

Using your exmple:

=MIN(A2:A50)*2.50


<(E-Mail Removed)> wrote in message
news:2f3c41a1-2b1e-49ca-9204-(E-Mail Removed)...
>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?