Thread: IF Q
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Sean is offline
external usenet poster
 
Posts: 454
Default IF Q

How do I say the following

=IF(B8=Thursday,2,0) i.e. Return the value 2 if B8 returns
"Thursday"

Where B8 is a date but it is formatted to show the day


Thanks