View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Max Mariola
 
Posts: n/a
Default Get the Starsign given a date in a table

I have a table with the dates for each starsign. Entering a date into a
cell, I want Excel to work out what the starsign is from the table. I used
the IF statement, but I cant nest more than 7 IF statements. How would one
do this?