Forum Discussion
IF statement - Empty cell to be blank
Hi, I'm fairly basic with my excel knowledge. I have the below formula and table. The break column is a drop down box with selected times, I want the lunch column to return either a time of 12:15...
Let me suggest that you acquaint yourself with the IFS function, to allow for more than two conditions. You could test for 10, 11, ISBLANK, and any number of other conditions, providing a different response depending on which condition exists.