View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
CC[_3_] CC[_3_] is offline
external usenet poster
 
Posts: 4
Default Data Validation - IF statements

I am having problems with 7 Nested IF functions in data validation.
What is the best way around formulas using more than 7 IF functions?
How do you write an IF function in VBA where there are more than seven
statements?
Thanks