Solved

Formula to remove NaN when 0/0

+4

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 !

Best answer by Yeshi_Wang

Update your formula to:

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

+4

Update your formula to:

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

+4

Thank you!

+3

Update your formula to:

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

Very helpful!

Sign up