eliminating types of missing data from final formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

exluding missing data values from equation 4
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Summary of data using array formula 1
Missing data 1
Using the contents of a ADDRESS formula as the cell range in a for 3
Formula 5
Excel Excel Vlookup formula based on cell data 7
Creating a formula that references the last value of a column 10

Back
Top