View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bluebird bluebird is offline
external usenet poster
 
Posts: 5
Default Two TRUE to one FALSE statement

Would like to create a formula that can return one of two true outcomes vs.
one false. For example:

if date2 (c2) < date1 (b2), then "early",
if date2 (c2) = date1 (b2), then "on time",
if date2 (c2) date2 (b2), or if %(d2)<1, then "late".

Can this be done? Any help greatly appreciated!