Forum Discussion

Copper Contributor

Sep 22, 2017

iferror error in formulator based of div0

I am using the following formula: =IF($A19="","",($G19/VLOOKUP($A19,data.xlsx!A$3:E$5118,2,FALSE))) I am getting the div0 error in some of the cells and do not want it showing for those cells. i...

Formulas & Functions

Need Help

Detlef_Lewin

Silver Contributor

Sep 22, 2017

Victor,

simply:

=IFERROR(IF($A19="","",($G19/VLOOKUP($A19,data.xlsx!A$3:E$5118,2,FALSE))),0)