Skip to main content

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.

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

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

Thank you very much @Alexey_Gusev .


Reply