Forum Discussion
CheekyMonkey22
Dec 07, 2024Copper Contributor
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...
JonCosmosGenerate
Dec 09, 2024Copper Contributor
Hi - are you using =ISBIANK() or =ISBLANK()?
Note that the first one is not an Excel function, hence, the error.
=ISBLANK() **is** an Excel function.