Price comparison...

  • Thread starter Thread starter John84
  • Start date Start date
J

John84

Hi Guys,

Here's my problem....

I have two columns with prices from two different sources. On a thir
column, is where I would like the price from the cheaper source to be
Is there a way i can do this without having to do it manually?

I hope I was specific enough for you guys. Thanks in advance
 
Hi John,

Assume your two price columns are columns B and C.
Assume your first price row is row 2.

In cell D2 enter the formula:

=min(B2:C2)

Now drag (or copy) down the formula in D2 for as many rows as you need.

Adjust B, C and the row number to suit your situation.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Raspberry Pi 2 energy monitor with Inky pHAT (ePaper/eInk/EPD). 2
how to set the Default Value of a Control Box to a Lookup Table 0
Is this possible with excel ? 9
conditional formating greater than 1
Highlighting a cell 6
matching values in columns to update prices 3
Formula for worksheet that's tallying and pricing 5
Combine Multiple Worksheets 2

Back
Top