Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

What's (#NUM!) in Bounce rate & Exit Rate?

ajayk2937920
Level 1
Level 1

Hi Team,

Could you please guide me for the below-mentioned concern. What is the meaning of special character data (#NUM!) signification in Bounce rate & Exit Rate calculation. is it equal to 0.00% or data error?

Thanks & Regards,

Ajay Tiwari

1 Reply
Balaji_V
Level 5
Level 5

Hi Ajay,

Is it Excel shows this error when a formula or function contains numeric values that aren't valid. (If your Data block had reference to formula)

Reference error This often happens when you’ve entered a numeric value using a data type or a number format that’s not supported in the argument section of the formula.

Check on below link for solution

https://exceljet.net/formula/how-to-fix-the-num-error

Thanks,

Balaji