View Single Post
  #1  
Old June 16th, 2004, 05:46 PM
external usenet poster
 
Posts: n/a
Default data validation & formulas

Hello great folks who have saved me more than once:

I have a data validation list (drop down list) in one
cell, which offers a choice of 3 different selections; in
the next cell I have a formula (would like to have a
formula for each validation). Is it possible to create a
formula that says if this is chosen in the data validation
box, use this formula, if something else is chosen from
the drop down box use another formula, etc? Thus, a
different formula for each choice in the validation list.
Thank you in advance