| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have a list of data, fill in the gaps. FILL function won't work | Excel Discussion (Misc queries) | |||
| Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
| The fill feature in Excel that gives option to fill or copy | New Users to Excel | |||
| How to fill colour in Excel, it appers No fill in my computer? | Excel Discussion (Misc queries) | |||
| Excel printing problem - won't print cell under a "fill effect" bo | Excel Discussion (Misc queries) | |||
Threaded Mode
