Help

I want to remove the Nan statement from a cell.

Topic Labels: Data Formulas
Solved
Jump to Solution
1147 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Can_eCommerce
4 - Data Explorer
4 - Data Explorer

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.

1 Solution

Accepted Solutions
Alexey_Gusev
13 - Mars
13 - Mars
IF(Erreicht!=0,Terminier/Erreicht) - show nothing
IF(Erreicht!=0,Terminier/Erreicht,0) - show 0

See Solution in Thread

2 Replies 2
Alexey_Gusev
13 - Mars
13 - Mars
IF(Erreicht!=0,Terminier/Erreicht) - show nothing
IF(Erreicht!=0,Terminier/Erreicht,0) - show 0

Thank you very much @Alexey_Gusev .