Share via

NBVAL not working

Anonymous
2016-05-04T13:33:01+00:00

The NB family of functions are missing from my Excel.

ex: NBVAL is not recognised.

I recently reinstalled Office Home and Business 2013 after upgrading to Windows 10. Before the update and reinstall i used to have these functions which all worked properly.

Has it been replaced by the count family of functions?

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

Answer accepted by question author

Anonymous
2016-05-05T03:39:52+00:00

Hi Roussel,

If you are referring to the French language function NBVAL, the English equivalent function is COUNTA, Other functions which may be of interest to you are:

French` English
NB COUNT
NB.COUPONS COUPNUMBER
NB.JOURS.COUPONS.PREC COUPDAYBS
NB.JOURS.COUPONS.SUIV COUPDAYSNC
NB.JOURS.COUPONS COUPDAYS
NB.JOURS.OUVRES NETWORKDAYS
NB.SI COUNTIF
NB.VIDE COUNTBLANK
NBCAR LEN

===

Regards,

Norman

Was this answer helpful?

6 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-05-05T02:00:15+00:00

    Hello Roussel,

    Thank you for posting

    Before we proceed, I need more information to help you better.

    -Are you referring to NUMBERVALUE function?

    -If yes, what happens when you try to use this function?

    I look forward to your reply to assist you further.

    Thank you.

    Was this answer helpful?

    0 comments