Share via

IF statements with ISERROR

Anonymous
2012-08-24T18:38:33+00:00

I am using either of the following formulas: 

=IF(AS16081="sched'd",(X16081-N16081)*1440,(X16081-K16081)*1440)

=IF(AS16081="sched'd",(X16081-N16081)*1440,IF(AS16081="demand",(X16081-K16081)*1440))      

I want the cell to be blank if the result is an error.  Do I use ISERROR and how?

I am on ashort timeline so a quick response would be greatly appreciated.

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

  1. Anonymous
    2012-08-27T11:52:24+00:00

    try

    =IF(ISERROR(IF(AS16081="sched'd",(X16081-N16081)*1440,IF(AS16081="demand",(X16081-K16081)*1440)))=FALSE,"",IF(AS16081="sched'd",(X16081-N16081)*1440,IF(AS16081="demand",(X16081-K16081)*1440)))

    =IF(ISERROR(IF(AS16081="sched'd",(X16081-N16081)*1440,IF(AS16081="demand",(X16081-K16081)*1440)))=FALSE,"",IF(AS16081="sched'd",(X16081-N16081)*1440,IF(AS16081="demand",(X16081-K16081)*1440)))

    2 people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2012-08-25T15:57:00+00:00

    Hi,

    try this...

    = IF(ISERROR(your formula),"",your formula)

    your formula…..

    IF(AS16081="sched'd",(X16081-N16081)*1440,(X16081-K16081)*1440)

    or

    IF(AS16081="sched'd",(X16081-N16081)*1440,IF(AS16081="demand",(X16081-K16081)*1440))

    2 people found this answer helpful.
    0 comments

9 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-08-24T19:08:25+00:00

    Thank you so much!!!!!!

    0 comments
  2. Anonymous
    2012-08-24T18:53:55+00:00

    Use IFERROR() instead:

    =IFERROR(your_formula,"")

    0 comments
  3. Anonymous
    2012-08-24T18:51:46+00:00

    Hi, not use iferror

    =IFERROR(IF(AS16081="sched'd",(X16081-N16081)*1440,(X16081-K16081)*1440),"")

    =IFERROR(IF(AS16081="sched'd",(X16081-N16081)*1440,IF(AS16081="demand",(X16081-K16081)*1440)) ,"")

    0 comments