if statement

[Faisalomran1]

hi so I have the following this column as a "double" format and I would like to change the "null" values and "0" values to 100.

if a value in the column neither "0" nor " null" I want it to stay the same.

I want the changes to be on the same column ( no new column for the new values)

thank you in advance.

 

[JosephSerpis · Accepted solution]

Hi @Faisalomran1 I mocked up a workflow let me know what you think?