Jun 19, 2023 01:19 AM
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.
Solved! Go to Solution.
Jun 19, 2023 01:38 AM
IF(Erreicht!=0,Terminier/Erreicht) - show nothing
IF(Erreicht!=0,Terminier/Erreicht,0) - show 0
Jun 19, 2023 01:38 AM
IF(Erreicht!=0,Terminier/Erreicht) - show nothing
IF(Erreicht!=0,Terminier/Erreicht,0) - show 0
Jun 19, 2023 01:53 AM
Thank you very much @Alexey_Gusev .