- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 01, 2023 11:06 AM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 01, 2023 05:28 PM
Update your formula to:
IF({# of Managers},{Surveys Recieved-MGR}/{# of Managers})

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 01, 2023 05:28 PM
Update your formula to:
IF({# of Managers},{Surveys Recieved-MGR}/{# of Managers})
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 02, 2023 08:32 AM
Thank you!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 29, 2024 12:40 PM
Very helpful!
