Forum Discussion

Troy_Stouffer's avatar
Troy_Stouffer
Copper Contributor
Oct 23, 2024

Destination cell displays either a value or 0.0

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.

Formulas and Functions

1 Reply

  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Oct 23, 2024

    Troy_Stouffer 

    On sheet G1 Cert:

      =IF( ISBLANK( 'G1 Data Entry'!AF100 ), "", 'G1 Data Entry'!AF100 )
// or
  =IF( 'G1 Data Entry'!AF100 <> "", 'G1 Data Entry'!AF100, "" )

    First option is for a really BLANK (empty) cell 'G1 Data Entry'

Resources