Skip to main content
Solved

I want to remove the Nan statement from a cell.

  • June 19, 2023
  • 2 replies
  • 35 views

Forum|alt.badge.img+1

Hello guys, 

i have a table where i calculate some values which can also have a Zero.
That means that i sometimes get 3/0 which leads to a Nan error.

I already tried a couple of formulas but i do not get it. 


So my question right now is how can i put the cells which would have Nan as a value to 0? 

I would be happy for a solution. 
Thank you.

Best answer by Alexey_Gusev

IF(Erreicht!=0,Terminier/Erreicht) - show nothing IF(Erreicht!=0,Terminier/Erreicht,0) - show 0

2 replies

Alexey_Gusev
Forum|alt.badge.img+25
  • Brainy
  • 1260 replies
  • Answer
  • June 19, 2023
IF(Erreicht!=0,Terminier/Erreicht) - show nothing IF(Erreicht!=0,Terminier/Erreicht,0) - show 0

Forum|alt.badge.img+1
  • Author
  • New Participant
  • 1 reply
  • June 19, 2023
IF(Erreicht!=0,Terminier/Erreicht) - show nothing IF(Erreicht!=0,Terminier/Erreicht,0) - show 0

Thank you very much @Alexey_Gusev .