Help

Re: Formula to remove NaN when 0/0

Solved
Jump to Solution
1158 0
cancel
Showing results for 
Search instead for 
Did you mean: 
sjohnson
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi I am trying to figure out how to remove the NaN value when the formula is 0/0

I need it to reflect 0.  I have tried IF() and IF(And( formula's but I cant seem to get it to work 

sjohnson_0-1677697481270.png

current formula is 

{Surveys Recieved-MGR}/{# of Managers}
 
Does anyone have any solutions?
Thanks !
1 Solution

Accepted Solutions
Yeshi_Wang
4 - Data Explorer
4 - Data Explorer

Update your formula to:

IF({# of Managers},{Surveys Recieved-MGR}/{# of Managers})

See Solution in Thread

2 Replies 2
Yeshi_Wang
4 - Data Explorer
4 - Data Explorer

Update your formula to:

IF({# of Managers},{Surveys Recieved-MGR}/{# of Managers})

sjohnson
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you!