Help with formula

[djs6025]

Hi Everybody,
I'm looking for a formula to put in column C that will display the lowest price from each row in column A and B. Some of the cells contain "N/A" so I want to make sure it doesn't return an error. I greatly appreciate any help you can give.

Example:

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]N/A[/TD]
[TD]11.49[/TD]
[TD]11.49[/TD]
[/TR]
[TR]
[TD]5.49[/TD]
[TD]4.44[/TD]
[TD]4.44[/TD]
[/TR]
[TR]
[TD]17.99[/TD]
[TD]N/A[/TD]
[TD]17.99
[/TD]
[/TR]
[TR]
[TD]18.99[/TD]
[TD]N/A[/TD]
[TD]18.99[/TD]
[/TR]
[TR]
[TD]9.99[/TD]
[TD]10.99[/TD]
[TD]9.99[/TD]
[/TR]
</tbody>[/TABLE]

Thanks,
Dan

 

[Cross Terrier]

=IF(ISNUMBER(A2),IF(ISNUMBER(B2),IF(A2>B2,B2,A2),A2),B2)

Assuming that one of the values in the columns is always a number. If not, what would you want to put in column C?

 

[djs6025]

That worked perfectly! Thanks so much!

 

[krrishkrsna]

try below formula

=AGGREGATE(15,6,A1:B1,1)

value 1 (after A1:B1 range) indicates first small value from range, 2 indicates second small value from range and so on