Share via

IF Error Nested Formula Returns False instead of Zero

Anonymous
2019-11-04T22:02:21+00:00

I have the following nested formula which still returns False instead of number Zero:

=IFERROR(IF(VLOOKUP($B9,'WA''s per LI'!$A$5:$G$600,6,0)>=$O9,VLOOKUP($B9,'WA''s per LI'!$A$5:$G$600,6,0)-$O9),0)

The last zero in the formula should tell the calculation to return a zero instead of the word False. I also tried changing that last zero to a "" and "0", even "-" which be acceptable, however, in all cases it stills returns False. Could it be related to the IF formula or the VlookUp?

Any suggestions from the experts?

Thanks,

Ana

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2019-11-04T22:12:10+00:00

    Try this version:

    =IFERROR(IF(VLOOKUP($B9,'WA''s per LI'!$A$5:$G$600,6,0)>=$O9,VLOOKUP($B9,'WA''s per LI'!$A$5:$G$600,6,0)-$O9,0),0)

    or, somewhat shorter:

    =IFERROR(MAX(VLOOKUP($B9,'WA''s per LI'!$A$5:$G$600,6,0)-$O9,0),0)

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2019-11-04T22:09:15+00:00

    Hi AGM1985,

    I am Irfanul, an Independent advisor. The reason that your formula was returning a false value instead of 0 is that you forgot to use the False value in the IF formula. Which I have add in the second vlookup

    =IFERROR(IF(VLOOKUP($B9,'WA''s per LI'!$A$5:$G$600,6,0)>=$O9,VLOOKUP($B9,'WA''s per LI'!$A$5:$G$600,6,0)-$O9,0),0)

    I hope this you solve your problem, and return zero.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments