Skip to main content

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 

current formula is 

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

Update your formula to:

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


Thank you!


Update your formula to:

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


Very helpful!


Reply