Source cell options, either a Field Technician entered value or blank

Source cell is on Sheet “G1 Data Entry” Cell E20

I want that value to be displayed on a Certification Sheet “G1 Cert” Cell AF100.

I currently have on Certification Sheet “G1 Cert” in Cell AF100

=’G1 Data Entry’!E20

 “G1 Cert” in cell AF100 displays the value correctly, but if Sheet “G1 Data Entry” Cell E20 is blank it displays 0.0

How do I get the destination cell Sheet “G1 Cert” Cell AF100 to be blank also if the source cell is in fact blank? I cannot simply just hide the zero values on my destination sheet as I have other conditions where I need those zero’s to in fact be displayed.

​Source cell options, either a Field Technician entered value or blankSource cell is on Sheet “G1 Data Entry” Cell E20I want that value to be displayed on a Certification Sheet “G1 Cert” Cell AF100.I currently have on Certification Sheet “G1 Cert” in Cell AF100=’G1 Data Entry’!E20 “G1 Cert” in cell AF100 displays the value correctly, but if Sheet “G1 Data Entry” Cell E20 is blank it displays 0.0 How do I get the destination cell Sheet “G1 Cert” Cell AF100 to be blank also if the source cell is in fact blank? I cannot simply just hide the zero values on my destination sheet as I have other conditions where I need those zero’s to in fact be displayed.  Read More

​