| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formulas
I have created a spreadsheet with a formula which takes information from
other cells to enter the appropriate result which is fine. My problem is that some of the answers apply if the cells are blank so enter a result but i want to ensure that the sheet stays blank until the relevant data is entered? Any ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formulas
=IF(A1="","",your_formula)
-- David Biddulph "sd270264" wrote in message ... I have created a spreadsheet with a formula which takes information from other cells to enter the appropriate result which is fine. My problem is that some of the answers apply if the cells are blank so enter a result but i want to ensure that the sheet stays blank until the relevant data is entered? Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ms-excel guidence notes, complete formulas in excel, How to runmacros in Ms excel | Excel Discussion (Misc queries) | |||
| CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
| Copying formulas from Excel 2003 to Excel 2007 | Excel Discussion (Misc queries) | |||
| Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
| excel formulas | Excel Discussion (Misc queries) | |||
Linear Mode
