Compare and creat a result

  • Thread starter Thread starter DavidM
  • Start date Start date
D

DavidM

I have two columns of figures (prices), one from Jbloggs
and the other Another.
How can I automatically compare each pair of figures and
indicate the lowest of the two in a third column?

Many thanks

david
 
I have two columns of figures (prices)

Ken gave you an answer based on the information supplied, I'm curious as to
where the other info is, ie: prices of what?

Ken's will tell you the lowest price. However, you may need

=IF(A1=B1,"either",IF(A1<B1,"jbloggs","another"))

HTH,
Andy
 
Back
Top