View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SueJB
 
Posts: n/a
Default Syntax for IF with multiple criteria

Hello all

Would any kind soul help me here? I've read all the posts around this but
they're just not sinking in today.

I need to put a text value in column C based on a numerical value in column
B based on:

If B2=4,8,10 or 12 then C2="Jones" else C2="Smith"

I'm sure it will be simple :-(

Thanks in advance
Sue