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...
Try this:
=IF(ISBLANK(B4), "", IF(MINUTE(B4) = 10, "12:15", IF(MINUTE(B4) = 11, "13:15", "")))
