| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
extend formula when data is entered
I want to have results shown only when I input data. At the moment the cell
formula is using 0 in place of blank cells to give the wrong answer. Help |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
extend formula when data is entered
=IF(A1="","",your formula)
"Kate" wrote: I want to have results shown only when I input data. At the moment the cell formula is using 0 in place of blank cells to give the wrong answer. Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find value in array | Excel Worksheet Functions | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
| Macro question | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
