Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
check to see if a cell is blank if not populate adjacent cell wit.
Hello need help with a formuala. In a spreadsheet I want to check and see
iif a cell contains text, if so, I want to populate an adjacent cell with the current date. If the cell is blank I dont want to do anything... Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
check to see if a cell is blank if not populate adjacent cell wit.
=IF(ISTEXT(A1),TODAY(),"")
You haven't said what you want to do if the cell contains a number (which is not text and not blank). If you want the current date for any entry (text or number), then try =IF(A1<"",TODAY(),"") -- David Biddulph "Frusterated" wrote in message ... Hello need help with a formuala. In a spreadsheet I want to check and see iif a cell contains text, if so, I want to populate an adjacent cell with the current date. If the cell is blank I dont want to do anything... Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
check to see if a cell is blank if not populate adjacent cell
David,
Thanks for the advice. Unfortunately the formula only returned the word "FALSE", which is incorrect as there is some text in the cell. Text or no text the result is always the word "False". To answer your first question, I dont care if its text or numbers, as long as its populated I would like to populate the adjacent cell with todays date. "David Biddulph" wrote: =IF(ISTEXT(A1),TODAY(),"") You haven't said what you want to do if the cell contains a number (which is not text and not blank). If you want the current date for any entry (text or number), then try =IF(A1<"",TODAY(),"") -- David Biddulph "Frusterated" wrote in message ... Hello need help with a formuala. In a spreadsheet I want to check and see iif a cell contains text, if so, I want to populate an adjacent cell with the current date. If the cell is blank I dont want to do anything... Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
check to see if a cell is blank if not populate adjacent cell wit.
Maybe:
=if(a1="","",today()) Be aware that this formula will change when you open the workbook on a different date (and the workbook recalcs). If you want to keep track of when the data changed, maybe using J.E. McGimpsey's worksheet event macro: http://www.mcgimpsey.com/excel/timestamp.html Frusterated wrote: Hello need help with a formuala. In a spreadsheet I want to check and see iif a cell contains text, if so, I want to populate an adjacent cell with the current date. If the cell is blank I dont want to do anything... Thanks. -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
check to see if a cell is blank if not populate adjacent cell
Post the *exact* formula that is returning FALSE. Neither one of David's
formulas will return FALSE! -- Biff Microsoft Excel MVP "Frusterated" wrote in message ... David, Thanks for the advice. Unfortunately the formula only returned the word "FALSE", which is incorrect as there is some text in the cell. Text or no text the result is always the word "False". To answer your first question, I dont care if its text or numbers, as long as its populated I would like to populate the adjacent cell with todays date. "David Biddulph" wrote: =IF(ISTEXT(A1),TODAY(),"") You haven't said what you want to do if the cell contains a number (which is not text and not blank). If you want the current date for any entry (text or number), then try =IF(A1<"",TODAY(),"") -- David Biddulph "Frusterated" wrote in message ... Hello need help with a formuala. In a spreadsheet I want to check and see iif a cell contains text, if so, I want to populate an adjacent cell with the current date. If the cell is blank I dont want to do anything... Thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
check to see if a cell is blank if not populate adjacent cell wit.
Hi,
May be this works for you: =IF(ISBLANK(A1),"",TODAY()) Thanks, -- Farhad Hodjat "Frusterated" wrote: Hello need help with a formuala. In a spreadsheet I want to check and see iif a cell contains text, if so, I want to populate an adjacent cell with the current date. If the cell is blank I dont want to do anything... Thanks. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
check to see if a cell is blank if not populate adjacent cell
You didn't enter the formula correctly. For you to get a result of "false", you
put a closing bracket in the wrong place. Compare what you entered to David's formula, and correct any errors. -- Regards, Fred "Frusterated" wrote in message ... David, Thanks for the advice. Unfortunately the formula only returned the word "FALSE", which is incorrect as there is some text in the cell. Text or no text the result is always the word "False". To answer your first question, I dont care if its text or numbers, as long as its populated I would like to populate the adjacent cell with todays date. "David Biddulph" wrote: =IF(ISTEXT(A1),TODAY(),"") You haven't said what you want to do if the cell contains a number (which is not text and not blank). If you want the current date for any entry (text or number), then try =IF(A1<"",TODAY(),"") -- David Biddulph "Frusterated" wrote in message ... Hello need help with a formuala. In a spreadsheet I want to check and see iif a cell contains text, if so, I want to populate an adjacent cell with the current date. If the cell is blank I dont want to do anything... Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Check colour of number, then populate cell | Excel Worksheet Functions | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
Counting cells with blank adjacent cell | Excel Worksheet Functions | |||
How can I check a cell for current date and insert it if blank? | New Users to Excel | |||
Excel VB-Copy formula down until adjacent cell (left) is blank? | Excel Discussion (Misc queries) |