I’m working on a Google Sheets formula and need some help. I want to check if certain cells are empty and then do different things based on that.
Here’s my current attempt:
=if(ISEMPTY(B:B), "", (B:B+TIME(3, 30, 0)))
What I’m trying to accomplish is this: if column B has data in it, I want to add 3.5 hours to those values. But if the cells in column B are empty, I just want the result to stay blank instead of showing an error.
Right now my formula isn’t working the way I expected. Does anyone know the correct way to structure this kind of conditional formula? I’ve been stuck on this for a while and would really appreciate any suggestions.
Had a similar issue recently and discovered that the problem often comes down to how Google Sheets interprets ‘empty’ cells. Sometimes cells that appear blank actually contain invisible characters or spaces, which can throw off your conditional logic. Before applying any formula, I recommend selecting your data range and using Find & Replace to remove any hidden spaces or characters. Another approach that worked well for me was using the LEN function combined with your condition: =ARRAYFORMULA(IF(LEN(B:B)=0, '', B:B+TIME(3,30,0))). This checks if the cell length is zero rather than relying on emptiness functions. The LEN approach tends to be more reliable when dealing with data that might have been imported or copied from other sources where true emptiness can be questionable.
try using ISBLANK instead of ISEMPTY - thats usually the issue. also you might need to use ARRAYFORMULA since ur working with whole columns. something like =ARRAYFORMULA(IF(ISBLANK(B:B), "", B:B+TIME(3,30,0))) should work better
The main problem with your formula is that ISEMPTY doesn’t work the way you think it does in Google Sheets. When you reference an entire column like B:B, ISEMPTY will check if the entire column is empty, not individual cells. What you need is to apply the condition to each cell individually. Try this approach: =ARRAYFORMULA(IF(B:B="", "", B:B+TIME(3,30,0))) - this checks each cell in column B to see if it equals an empty string rather than using ISEMPTY. The ARRAYFORMULA wrapper is essential when working with entire columns because it processes each row separately. I’ve used this pattern many times for similar conditional calculations and it handles blank cells much more reliably than the ISEMPTY function.