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
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
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.