Share via

If formula

Anonymous
2025-01-20T20:29:26+00:00

Hi all, I have taken over a spreadsheet from someone who left and although I understand the if formula there is something don't understand. It is a very simple formula which says if cell (A<0, "not done","done) however when I would expect to see not done or done in the cells in text the cell is completely empty but the formula works. How do you do that? There isn't any extra word on the formula which tells leave the cell blank.

Thanks

Microsoft 365 and Office | Excel | For business | Android

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 460.7K Reputation points MVP Volunteer Moderator
    2025-01-20T21:15:11+00:00
    • Check whether the font (text) color of that cell is the same as the fill (background) color.
    • Check the number format. A custom format such as ;;; (three semicolons) will hide all cell contents.
    0 comments