View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_6_] GS[_6_] is offline
external usenet poster
 
Posts: 1,182
Default req. for ideas for numeric worksheet

Mike,
Typically.., some sort of 'code' or 'flag' is used to show current
status. What these are is entirely user specific such as your
suggestion to use "n/r", for example. I'd avoid using a slash
character, though, as your example "n/a" is an intrinsic error flag.

You don't need to be consistent in the length of the status code IMO as
it's more benefit it be descriptive in context to its usage...

T0 = Taxable at TaxRate0 (0%)
T1 = Taxable at TaxRate1
T2 = Taxable at TaxRate2
NT = Not Taxable
TX = Tax Exempt
...and so on

HTH

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus