Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN YOU HELP WITH A FORMULA?
I am trying to ascertain from a list of dates which items need to be done.
Have used the "If" function and embedded the "TODAY" formula within that. I have tried this several ways, but cannot get it to work properly. The formula I have at the moment is =IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or not the date is before, after or on today, I get the same answer of "DO." Can you tell me where I'm going wrong? -- MARY |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN YOU HELP WITH A FORMULA?
Change your formula to:
=IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO",IF(J2TODAY( ),"DO"))) last if you can igno =IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO","DO")) pls do rate "Mary Mace" wrote: I am trying to ascertain from a list of dates which items need to be done. Have used the "If" function and embedded the "TODAY" formula within that. I have tried this several ways, but cannot get it to work properly. The formula I have at the moment is =IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or not the date is before, after or on today, I get the same answer of "DO." Can you tell me where I'm going wrong? -- MARY |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN YOU HELP WITH A FORMULA?
Nearly there but not quite... OKs are showing fine, but the "DOs" are coming
out with the #NAME? error. Any ideas? Thanks & regards, -- MARY "Muhammed Rafeek M" wrote: Change your formula to: =IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO",IF(J2TODAY( ),"DO"))) last if you can igno =IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO","DO")) pls do rate "Mary Mace" wrote: I am trying to ascertain from a list of dates which items need to be done. Have used the "If" function and embedded the "TODAY" formula within that. I have tried this several ways, but cannot get it to work properly. The formula I have at the moment is =IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or not the date is before, after or on today, I get the same answer of "DO." Can you tell me where I'm going wrong? -- MARY |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN YOU HELP WITH A FORMULA?
Ooooooooops Sorry. i forgot to put =
Change your formula to: =IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2TODAY (),"DO"))) last if you can igno =IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO","DO")) "Mary Mace" wrote: Nearly there but not quite... OKs are showing fine, but the "DOs" are coming out with the #NAME? error. Any ideas? Thanks & regards, -- MARY "Muhammed Rafeek M" wrote: Change your formula to: =IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO",IF(J2TODAY( ),"DO"))) last if you can igno =IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO","DO")) pls do rate "Mary Mace" wrote: I am trying to ascertain from a list of dates which items need to be done. Have used the "If" function and embedded the "TODAY" formula within that. I have tried this several ways, but cannot get it to work properly. The formula I have at the moment is =IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or not the date is before, after or on today, I get the same answer of "DO." Can you tell me where I'm going wrong? -- MARY |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN YOU HELP WITH A FORMULA?
Try this ...
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2TODAY (),"DO"))) Please rate me. "Mary Mace" wrote: I am trying to ascertain from a list of dates which items need to be done. Have used the "If" function and embedded the "TODAY" formula within that. I have tried this several ways, but cannot get it to work properly. The formula I have at the moment is =IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or not the date is before, after or on today, I get the same answer of "DO." Can you tell me where I'm going wrong? -- MARY |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN YOU HELP WITH A FORMULA?
Sorry if this comes up twice... I thought I had posted a message, but it
does not appear to be showing. Thanks for your help - I am half way there, but am still getting an error message. The "OKs" are coming out alright, but the "DOs" are coming up with a #NAME? error. Any ideas how to resolsve this? Thanks & regards, -- MARY "Muhammed Rafeek M" wrote: Change your formula to: =IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO",IF(J2TODAY( ),"DO"))) last if you can igno =IF(J2<TODAY(),"OK",IF(J2TODAY(),"DO","DO")) pls do rate "Mary Mace" wrote: I am trying to ascertain from a list of dates which items need to be done. Have used the "If" function and embedded the "TODAY" formula within that. I have tried this several ways, but cannot get it to work properly. The formula I have at the moment is =IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or not the date is before, after or on today, I get the same answer of "DO." Can you tell me where I'm going wrong? -- MARY |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN YOU HELP WITH A FORMULA?
or more simply....
=IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO")) Rob "Naveen" wrote in message ... Try this ... =IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2TODAY (),"DO"))) Please rate me. "Mary Mace" wrote: I am trying to ascertain from a list of dates which items need to be done. Have used the "If" function and embedded the "TODAY" formula within that. I have tried this several ways, but cannot get it to work properly. The formula I have at the moment is =IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or not the date is before, after or on today, I get the same answer of "DO." Can you tell me where I'm going wrong? -- MARY |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAN YOU HELP WITH A FORMULA?
Brilliant! Sorted! Thanks for your help.....
-- MARY "Naveen" wrote: Try this ... =IF(J2<TODAY(),"OK",IF(J2=TODAY(),"DO",IF(J2TODAY (),"DO"))) Please rate me. "Mary Mace" wrote: I am trying to ascertain from a list of dates which items need to be done. Have used the "If" function and embedded the "TODAY" formula within that. I have tried this several ways, but cannot get it to work properly. The formula I have at the moment is =IF(J2<"TODAY","OK",IF(J2="TODAY","DO",IF(J2"TODA Y","DO"))), but whether or not the date is before, after or on today, I get the same answer of "DO." Can you tell me where I'm going wrong? -- MARY |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |