View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tim m
 
Posts: n/a
Default Greeting Function

One thing to remember, unless I am mistaken the time from the NOW function
will only be updated in a cell when a recalculation is done. Will this
affect the formulas that a NOW is part of?

(As in if you just use a NOW formula it will list a time and date, that time
and date will remain as is unless you recalc to match with time passing on
your clock.)

"edwardpestian" wrote:


I have the following function. I'm trying to say that if it is before
12:00 pm, say "Good Morning," if after 12:00 pm but before 6:00 pm say
"Good Afternoon," and otherwise say "Good Evening". The function
however, is not working properly. Any ideas?

=IF(NOW()<TODAY()+HOUR(0.5),"Good Morning"&" "&"Today is"&"
"&TEXT(TODAY(),"mmmm dd, yyyy"),IF(NOW()<TODAY()+HOUR(0.75),"Good
Afternoon"&" "&"Today is"&" "&TEXT(TODAY(),"mmmm dd, yyyy"),"Good
Evening"&" "&"Today is"&" "&TEXT(TODAY(),"mmmm dd, yyyy")))

Any ideas?

Thanks.

ep


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=555043