Find lowest number in a row in a range of columns

[jaxs2009]

Running Excel 2016, in 2011 a good gentleman helped me with a formula here in Mr Excel in which I have lost, here is what I am needing to do again.

In cell A11, I need a formula that will find the lowest number in a range of columns lets say G11:P11, trick is if all cells in that row between the column range G11:P11 is formatted to accounting and reflecting no entry as I enter a number in each of the cells in that row between the column range I only want cell A11 to reflect the lowest entered number entered. If a cell has no entry then the formula needs ignore no entry cell(s) and find the lowest number.

Thank you to anyone who can help me, Jaxs2009

 

[Jonmo1]

If all cells between G11:P11 are blank cell A11 should reflect blank/zero

This is a communication problem we're having.

Blank and Zero are NOT the same thing.
Which do you want?

The plain formula =MIN(G11:P11) will in fact return 0 if all cells are blank.

 

[jaxs2009]

The formula =MIN(IF(G11:P11<>0,G11:P11)) works as paste with CTRL + SHIFT + ENTER but in Cell A11 where the formulas lives is reflecting a negative number? there will be no negative numbers ever entered.

I have to enter a negative number in cells between G11:P11 to get a positive number in cell A11, keep in mind I will never enter a negative number at anytime.

 

[jaxs2009]

I need zero, sorry for not knowing the difference.

 

[crazydragon84]

Jaxs, just post couple examples and what you want to see in column A. all of us are confused about what exactly you want.

 

[jaxs2009]

I GOT IT, it now works, thanks you everyone for putting up with me, it is so appreciated.

My last issue was a negative number reflecting in cell A11 from all positive numbers in G11:P11, so here it is =MIN(IF(G11:P11<>-0,G11:P11)) with CTRL + SHIFT + ENTER gave me a positive number in cell A11.