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

1. Question: how can i solve this problem in the above mentioned field.

Otherwise:

2. Question: how can i solve the problem in the origin field, so the response will not be "#NV" , but "0"

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

Sorry for my bad english.

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

You can wrap the formula in WENNNV.

4 Replies

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.

Resources