Calculation based on lowest price
 

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?

Calculation based on lowest price
 

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

Calculation based on lowest price
 

=MIN(rng)*other_value

--
---
HTH

Bob


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



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?

Calculation based on lowest price
 

Try this:

=A1*MIN(B1:F1)

--
Biff
Microsoft Excel MVP


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?

Calculation based on lowest price
 

On Dec 11, 4:26 pm, "Bob Phillips" wrote:
=MIN(rng)*other_value

--
---
HTH

Bob

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

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?- Hide quoted text -

- Show quoted text -

Thanks a ton, I just figured this out!

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!

Calculation based on lowest price
 

vjohns158,

Use the MIN() function:

=MIN(Range)

Using your exmple:

=MIN(A2:A50)*2.50


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?