Forum home » Delegate support and help forum » Microsoft Excel Training and help » If function

If function

ResolvedVersion 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

Thu 27 Feb 2014, 12:31 Delegate dave said...

RE: if function

Hi Doug, perfect and thank you for the speedy response.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Turn Function tooltips on and off

Excel 2002 (XP) and Excel 2003 have the Function tooltips facility. When you type in a function name followed by a bracket, for example, =IF(, a yellow box appears beside the function name and lists the function's arguments. This is very useful when you can't quite remember the order of a function's arguments or what the arguments actually are!

However, Function tooltips can become annoying. To turn them off, choose Tools|Options. and select the General tab. Then, untick the Function tooltips box and choose OK.

View all Excel hints and tips

If function

If function

RE: if function

RE: if function

Excel articles

Excel tip:

Turn Function tooltips on and off