View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
George George is offline
external usenet poster
 
Posts: 347
Default Allowing Only Certain Entrees

I am using the spreadsheet as a tracking mechanism, how do I format a cell so
it will only take a certain entry. For example, the formula is set to only
count s1 or s2 or s4. If someone hits s5 one data entry, I want the cell to
reject it.
Thanks