Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
eliminating types of missing data from final formula
Our project requires that we differentiate missing data and we have therefore
given it a number value rather than leave the cell empty (eg 999 for missing, 888 for not required, 777 for not applicable, etc). However in order to get correct calculations we need to be able to exclude these values. What can I do??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
eliminating types of missing data from final formula
hi,
one way.... type an apostrophe or quote mark in front of the number. excel will view these number as text and ignore them in calculations. Regards FSt1 "tam25" wrote: Our project requires that we differentiate missing data and we have therefore given it a number value rather than leave the cell empty (eg 999 for missing, 888 for not required, 777 for not applicable, etc). However in order to get correct calculations we need to be able to exclude these values. What can I do??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Numbers/Text data missing from excel to excel query? | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |