View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DP DP is offline
external usenet poster
 
Posts: 58
Default I need to evalute two cells and return a result

I am trying to evaluate two cells (ie: A2, B2)
Cell A2 data can be: yes,No,NA
Cell B2 data can be: yes,No,NA

I need to have Cell C3 return a result based on the combination of the A2,B2
data.
i.e.: If A2="Yes" and B2="No", then C2="V" or "IC" or "AT" and so on...

Thanks,