Forum Discussion

Troy_Stouffer's avatar
Troy_Stouffer
Copper Contributor
Oct 22, 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 AF10...
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 22, 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'