Thread: How do I write the IF function to reflect the result in one cell?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
  
Posts: 1,089
Default How do I write the IF function to reflect the result in one cell?
A1:
=IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1= "D&F",C1="RM"),"Ronald","")

Regards

Trevor


"AMBO" wrote in message
...
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