Thread: How do I write the IF function to reflect the result in one cell?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AMBO AMBO is offline
external usenet poster
  
Posts: 1
Default How do I write the IF function to reflect the result in one cell?
I want to yield in the 1st cell "William" when I choose "Grocery" in another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose "D&F" in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation mentioned above?
Reply With QuoteReply With Quote