Share via

Excel =IF(ISERROR(IF Not working

Anonymous
2017-06-30T08:13:44+00:00

Hi Everyone my first time posting on here so here goes Iv got a formula that works however when it can't find data will return ### Iv tried to add =IF(ISERROR(IF but can not get this to work here is my formula {=IF('Special Events'!$K$4:$K$515='Daily Planner'!$B$14,IF('Special Events'!$J$4:$J$515='Daily Planner'!$E$4,'Special Events'!$L$4:$L$515,"-"))}

Any help would be great thanks

Microsoft 365 and Office | Excel | For home | Windows

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

Answer accepted by question author

Anonymous
2017-06-30T08:41:15+00:00

So, the issue is not that the cells show ####, but that the formula returns FALSE, right?

Well, the formula returns FALSE if the condition of the IF statement is not met. 

Without seeing your data it is not possible to suggest how to fix that.  But if you get a FALSE, then there is  no cell in 'Special Events'!$K$4:$K$15='Daily Planner'!$B$14, because you don't specify a FALSE option for that IF statement.

Here is where the FALSE option needs to go:

=IF('Special Events'!$K$4:$K$15='Daily Planner'!$B$14,IF('Special Events'!$J$4:$J$15='Daily Planner'!$E$4,'Special Events'!$L$4:$L$15,"-"),"oops, something went wrong")

Was this answer helpful?

1 person found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-07-01T04:37:05+00:00

    LOL, I'm in New Zealand. Thanks for the feedback and happy to help.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2017-06-30T10:10:05+00:00

    I don't know where you are in the world but I could kiss you works fine thank you for your help.

    Jeff

    Was this answer helpful?

    0 comments
  3. Anonymous
    2017-06-30T08:27:24+00:00

    Hi Teylyn,

    Sorry forgot to add the ### when the cell is wide shows FALSE

    Was this answer helpful?

    0 comments
  4. Anonymous
    2017-06-30T08:21:45+00:00

    Hello,

    if a cell shows all #### signs, it contains a number or a date, but the column is not wide enough to display the value. Just make the column wider and you will see the value in its intended format.

    Point the mouse to the title column with the column letters. Position the mouse cursor on the line between two letters and notice how the mouse cursor changes from an arrow to a cross with arrows on the horizontal axis. Now you can left-click and drag this line to the right to make the column wider. When the column is wide enough, the number will show as formatted.

    Was this answer helpful?

    0 comments