Hi I am looking at some sales data where I'm comparing my price to my competitors. I want to know who has the lowest price compared to mine in any row.

Here's the example:

A1: $100.00 (this is my price)

B1: $101.95 (Competitor #1)
C1: $96.75 (Competitor #2)
D1: $98.75 (Competitor #3)
E1: (103.00 (Competitor #4)

When you look at this you can see clearly $96.75 is the lowest price. What is the formula that I would type in cell F1: to return me the price of $96.75

Thank you in advance for your support.

YR