Forum Discussion

Copper Contributor

Nov 29, 2022

Solved

Replace #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 "#...

excel

OliverScheurich
Nov 29, 2022
Peter_Franz
=WENNNV(SVERWEIS(C25;$1:$1048576;4;FALSCH);0)

You can wrap the formula in WENNNV.

OliverScheurich

Gold Contributor

Nov 29, 2022

Peter_Franz

=WENNNV(SVERWEIS(C25;$1:$1048576;4;FALSCH);0)

You can wrap the formula in WENNNV.

Peter_Franz
Copper Contributor
Nov 29, 2022
OliverScheurich
Wow! Thank you very much for the really quick answer.

I did it but unfortunately i got a failure message: " too many arguments for this function" .. Any idea?
- OliverScheurich
  Gold Contributor
  Nov 29, 2022
  Peter_Franz
  The formula returns the intended result. You can copy and paste the formula into your german Excel version and it will work. Perhaps you didn't copy the formula and manually entered too many arguments.
  - Peter_Franz
    Copper Contributor
    Nov 29, 2022
    Thanky our very much! I don`t know why but it works ! Great job! 😉
    
    I`m thinking about the fact that my formula looks like the same, as the copy of your formula. The arguments seems to be the same...