View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian
 
Posts: n/a
Default How do I make the true return a drop down list in the IF function?

=IF(B10="TWILL SHIRT",M2,0)

B10 IS A DROP DOWN LIST. I WOULD LIKE TO HAVE THE TRUE RETURN BE DIFFERENT
DROP DOWN LISTS CORRESPONDING TO EACH ITEM IN B10.