If function

Resolved · Low Priority · Version 2010

Thu 27 Feb 2014, 11:57 Delegate dave said...

dave has attended:
Excel Advanced course

If function

Hi. i have a cell that equals the value of another cell. what is happening at the moment is that if the "source"cell has no data then the "receiving" cell is placing a 0 there. im trying to make the cell show the value if there is one in the source cell, if there isnt a value then have nothing there. can you help?

Thu 27 Feb 2014, 12:22 Trainer Doug said...

RE: if function

Hi Dave

You can get the cell to display a blank instead of a zero by using an IF function.

=IF(Sheet2!A1="","",Sheet2!A1)

In this example if a A1 on Sheet2 is blank then receiving cell displays as blank. (Use a pair of double quotes to denote blank).
But if it is not blank then the value is displayed.

See if that works for your formula.

Doug Dunn
Best STL