=TEXT(I21,"MMYY")

[Guest]

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

 

[Beege]

=IF(I21="","unscheduled",TEXT(I21,"MMYY"))

Beege

 

[Guest]

You may try something like:
=IF(I21<>"",TEXT(I21,"MMYY"),"Unscheduled")

Hope this helps,
Miguel.

 

[Guest]

Will this work?

=IF(I21<>"",TEXT(I21,"MMYY"),"Unscheduled")

HTH,
Elkar

 

[Guest]

that makes all values return an "Unscheduled" value...I only want the "blank"
cells to read "unscheduled"

 

[Guest]

This returns the cell "100" when its supposed to return the date.

Im tottally following you here but something is a wrong...if I21 is "blank"
then put "unscheduled" if not put the month and year. it looks like this
should work but its returning "100"

 

[Beege]

Heath,

Then the cells must not be blank, really.

Try this

=IF(I21<30000,"unscheduled",TEXT(I21,"MMYY"))

(The 30000 is the number for a date around 1982, so if there's something
less than that, it will be unscheduled)

Beege

 

[Guest]

After looking at your reply to the answers that should have worked, I did a
little experimentation. Knowing that some people mask 0 values by setting
the option to not display 0's, I saw that that could cause a problem. Try
this formula:
=IF(A2=0,"",TEXT(A2,"mmyy"))

 

[Beege]

What exactly is in I21?

Beege

Heath,

Then the cells must not be blank, really.

Try this

=IF(I21<30000,"unscheduled",TEXT(I21,"MMYY"))

(The 30000 is the number for a date around 1982, so if there's something
less than that, it will be unscheduled)

Beege

 

[Guest]

That did it...you the man. Thank you.

After looking at your reply to the answers that should have worked, I did a
little experimentation. Knowing that some people mask 0 values by setting
the option to not display 0's, I saw that that could cause a problem. Try
this formula:
=IF(A2=0,"",TEXT(A2,"mmyy"))

 

[Guest]

You're welcome. Thanks for the feedback.