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)}}


Thank you. works perfectly :+1:

1 Like