Peter_FranzCopper ContributorNov 29, 2022SolvedReplace #NV with "0" Hi Experts! I have a (hopefully) simple Problem with replacing #NV with "0" I have a simple Addition =C4+D9+K9 and one of these fields is a "#NV" result, so the response in this field is also "#...Show MoreOliverScheurichNov 29, 2022Peter_Franz =WENNNV(SVERWEIS(C25;$1:$1048576;4;FALSCH);0) You can wrap the formula in WENNNV.
OliverScheurichNov 29, 2022Peter_Franz =WENNNV(SVERWEIS(C25;$1:$1048576;4;FALSCH);0) You can wrap the formula in WENNNV.
OliverScheurichNov 29, 2022Peter_Franz =WENNNV(SVERWEIS(C25;$1:$1048576;4;FALSCH);0) You can wrap the formula in WENNNV.
OliverScheurichGold ContributorNov 29, 2022Peter_Franz =WENNNV(SVERWEIS(C25;$1:$1048576;4;FALSCH);0) You can wrap the formula in WENNNV.
