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

Posted on Dec 27, 2024 6:08 PM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

how do i make this work if one of the cells is blank. trying to find the least value...if (b8

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.