I want a blank sheets cell when variable is null

I would like to have variables that are zero not show up in my sheets cell as a ‘0’, but a blank space. I tried something with the formulas, but got stuck. thanks!


scrnli_10_5_2023_1-31-43 AM

Use if condition , {{if(48.5 = 0; emptystring; 48.5)}}

3 Likes

Thank you. works perfectly :+1:

2 Likes