Forum Discussion
Help combine empty cell isblank with long formula (#DIV/0!)
Hi Stuck again Trying so many variations, I managed to do it yesterday but forgot to save it, not managing to figure out how I did it. So the dreaded #DIV/0! numbers can't be divided by 0...
mtarler the combination given gives an error and won't work unfortunately I'm trying to read through to see if I can spot the issue
If you can attach the workbook or give a link to it, I can see what the issue is
mtarler I thought I added a screenshot why isn't this letting me add a screenshot to my replies, screenshot had the exact error
- so based on the format of the formula you had/were trying I assume that it is a Table format, but that is the 1st thing to confirm. Next is to check which if any of the references Excel recognizes and see which it doesn't recognize. Just looking at the name they look correct but a double space vs a single space or many other things like that can be really hard to spot. So click on the formula in the edit bar/window and Excel should highlight in color the cell references it recognizes. It is also easier to click in the cell you want to reference and let Excel add that reference instead of manually typing it. For example you could type
=IF(
then click on the corresponding cell in the 'Miles Per Liter' column and Excel should insert that correct reference into the formula. Then you know the reference is recognized. - if you still can't attach here you could attach to a DM (direct message) by clicking my name and clicking 'Message'