fill in
Tim, thank you, it worked perfectly!
"tim m" wrote:
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.
"Anita" wrote:
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?
|