Comparing my price to the lowest competitor's price in an excel row

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

Hi yr25- paste this in F1:
=MIN(B1:E1)

=min(b1:e1)

My only issue with this formula is sometimes one of the cells has #N/A in the cell so for that row the formula comes back with #N/A
How do I get the formula to ignore the #N/A?

The #N/A is the result from another formula that return no result. Do I have to remove that #N/A to get this MIN formula to work ?

Thanks - YR

My only issue with this formula is sometimes one of the cells has #N/A in the cell so for that row the formula comes back with #N/A How do I get the formula to ignore the #N/A?

The #N/A is the result from another formula that return no result.
Do I have to remove that #N/A to get this MIN formula to work ?

Thanks - YR

Remove #N/A by wrapping IFERROR round your formulae ...

=IFERROR(your_formula,"")

#N/A means that the formula can't find what it's been asked to look for (generally wrong references), but using John's formula will help to an extent in the fact that whatever row shows the error will appear empty. However if you don't want the cell to appear blank I'd suggest attaching a sample spreadsheet with any confidential information removed as to see what if anything you possibly did wrong and try to correct it. Done through Go Advanced, Manage Attachment