How can I return a blank cell with IFERROR

Ian Davies 20 Reputation points


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


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,638 questions
0 comments No comments
{count} votes

Accepted answer
  1. Viorel 111.8K Reputation points

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

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful