View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cesar
 
Posts: n/a
Default How to apply more than one IF condition in 1 cell

i have 3 dates referring to a period and where i want under the formula cells
to have the following
if the value of the header of the table which is dats is between the first 2
dats than 1 for true and 0 for false and if the date in the header is between
the 2nd and third date than 2 for true and 0 for false

what is the formula