Thread: How do I show a "list" in an "if" statement?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom tom is offline
external usenet poster
  
Posts: 570
Default How do I show a "list" in an "if" statement?
I would like to be able to show a list 1,2,3,4,5, based upon a reference to a
cell stating yes or no.

Here's what I have so far

=if(k10="No","No Rock Indicated",if(k10="Yes"...I would like now to
reference to a drop down list of 1,2,3,4,5..

Can anyone help
--
Tom
Reply With QuoteReply With Quote