fill in

[Guest]

I have one workbook with three sheets. Two of the sheets are FormA and FormB
and the third sheet is called Fill In and I use it to fill in the
information on FormA and FormB. Here is an example of the formula I am using
='fill in '!B3. Here is my question. If I have this formula in place in FormA
and FormB and on the fil in I leave the cell blank then I get the value of
"0" on FormA and FormB. If I want to leave the cell blank on the fill in
worksheet and have a blank cell correspond to FormA and FormB how do I do it?

 

[Liz]

You could use an IF statement to leave a null value, but here's a shortcut
that I use if you just don't want to see the "0".

Format > Conditional Formatting
Cell Value Is equal to 0
Format font to be white

 

[Guest]

This might not be elegant but it works.

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

If A1 in sheet 3 is a blank it puts a blank in the cell, otherwise it puts
the value in.

 

[Guest]

Tim, thank you, it worked perfectly!

This might not be elegant but it works.

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

If A1 in sheet 3 is a blank it puts a blank in the cell, otherwise it puts
the value in.