View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Thank you, Heath
 
Posts: n/a
Default =TEXT(I21,"MMYY")

This formula looks at a cell and replaces the full date with jst the month
and the year....but some cells are blank, in this case this formula sends
back "100"

I need to add something to this formula that when the cell is
blank...instead of putting "100" as it does now, I need it to put
"Unscheduled"...

Like "If 100, then "Unsdchedule"

thanks a tonne.
Heath
Atlanta