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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,902 questions
0 comments
Accepted answer
  1. Viorel 121.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.