View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MayJuneJuly MayJuneJuly is offline
external usenet poster
 
Posts: 17
Default IF - And - Then Statement question

Could you help me to write and if-and-then statement?

example:
Col A Col B

C BSY

I am trying to have the statement read: IF Column A = C AND Column B = BSY,
THAN Column A = W