Thread: If/Then Matrix? Can Excel do this?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
D[_6_] D[_6_] is offline
external usenet poster
  
Posts: 34
Default If/Then Matrix? Can Excel do this?
Hey guys- got a semi-easy one here...

I have a range of dates that I need a specific code associated with each
year. For example- if the year is 1982, the code to use in this cell is
..9445. If the year is 1993, the code is .9669, and so on. This will run in a
macro eventually. How/where do I write this, and, can Excel do something
like this? IE- can Excel 'store' a 'matrix' of codes for each year? I hope
this is making sense.
Bbtw, it doesnt HAVE TO work in a macro- it'd be pretty cool if it could
actually work automatically as soon as the date was entered into a specific
cell, but a macro would work too... THANKS!
Thanks!
D




Reply With QuoteReply With Quote