Formula to remove NaN when 0/0

[sjohnson]

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 !

[Yeshi_Wang · Accepted solution]

Update your formula to:

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

[sjohnson]

Thank you!

[Matt_DeGrand]

Very helpful!