Thread: Using and if/then functions?? With a drop down menu?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Using and if/then functions?? With a drop down menu?
Let's say A1 has a data validation pull-down with the opions:

dog
guppy
rose

In B1, enter:

=IF(A1="dog","mammal",IF(A1="rose","flower","fish" ))

--
Gary''s Student - gsnu200777


"Maria13" wrote:

How can I program a worksheet that if a certain text is chosen from a drop
down menu it automatically records certain values in other fields?
Reply With QuoteReply With Quote