=TEXT(I21,"MMYY")

T

Thank you, Heath

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
 
M

Miguel Zapico

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

Hope this helps,
Miguel.
 
T

Thank you, Heath

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

Thank you, Heath

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"
 
B

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
 
K

Kevin Vaughn

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"))
 
B

Beege

What exactly is in I21?

Beege

Beege said:
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
Click to expand...
 
T

Thank you, Heath

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

Kevin Vaughn said:
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"))
Click to expand...
 
Top