Share via

How can I return a blank cell with IFERROR

Ian Davies 20 Reputation points
2023-08-29T11:46:55.6066667+00:00

Hi,

I'm not the best on Excel. What I'm trying to do is return a blank cell in C24 if there is no data in A24. I've been trying ISBLANK and "" but having no joy in applying a successful formula, any ideas?

User's image

Thanks in advance

Ian

Microsoft 365 and Office | Excel | For business | Windows
0 comments
Accepted answer
  1. Viorel 122.6K Reputation points
    2023-08-29T16:17:33.7466667+00:00

    Try this formula: =IFERROR(B24/A24,"").

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.