how do i make this work if one of the cells is blank. trying to find the least value...if (b8
It’s comparing 3 and telling me in another cell which number is lowest. It works fine unless one of the cells are blank. Then it does not show anything. How do I ignore a cell if it’s blank in n this formula….. if (b8<c8,if(b8<d8,”b”,”d”),”c” It works fine as long as all 3 cells have a number but I can’t put a zero in the blank ones because it would win the argument by default
iPhone 14