Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(I21,"MMYY")
=IF(I21="","unscheduled",TEXT(I21,"MMYY")) Beege "Thank you, Heath" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(I21,"MMYY")
You may try something like:
=IF(I21<"",TEXT(I21,"MMYY"),"Unscheduled") Hope this helps, Miguel. "Thank you, Heath" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(I21,"MMYY")
Will this work?
=IF(I21<"",TEXT(I21,"MMYY"),"Unscheduled") HTH, Elkar "Thank you, Heath" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(I21,"MMYY")
that makes all values return an "Unscheduled" value...I only want the "blank"
cells to read "unscheduled" "Miguel Zapico" wrote: You may try something like: =IF(I21<"",TEXT(I21,"MMYY"),"Unscheduled") Hope this helps, Miguel. "Thank you, Heath" wrote: 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(I21,"MMYY")
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" wrote: =IF(I21="","unscheduled",TEXT(I21,"MMYY")) Beege "Thank you, Heath" wrote in message ... 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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(I21,"MMYY")
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 "Thank you, Heath" wrote in message ... 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" wrote: =IF(I21="","unscheduled",TEXT(I21,"MMYY")) Beege "Thank you, Heath" wrote in message ... 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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(I21,"MMYY")
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")) -- Kevin Vaughn "Thank you, Heath" wrote: 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" wrote: =IF(I21="","unscheduled",TEXT(I21,"MMYY")) Beege "Thank you, Heath" wrote in message ... 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 |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(I21,"MMYY")
What exactly is in I21?
Beege "Beege" wrote in message ... 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 "Thank you, Heath" wrote in message ... 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" wrote: =IF(I21="","unscheduled",TEXT(I21,"MMYY")) Beege "Thank you, Heath" wrote in message ... 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 |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(I21,"MMYY")
That did it...you the man. Thank you.
"Kevin Vaughn" wrote: 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")) -- Kevin Vaughn "Thank you, Heath" wrote: 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" wrote: =IF(I21="","unscheduled",TEXT(I21,"MMYY")) Beege "Thank you, Heath" wrote in message ... 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 |
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=TEXT(I21,"MMYY")
You're welcome. Thanks for the feedback.
-- Kevin Vaughn "Thank you, Heath" wrote: That did it...you the man. Thank you. "Kevin Vaughn" wrote: 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")) -- Kevin Vaughn "Thank you, Heath" wrote: 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" wrote: =IF(I21="","unscheduled",TEXT(I21,"MMYY")) Beege "Thank you, Heath" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|