User name and greeting

[edwardpestian]

I have the following formula, which calls a function in order to get the
windows user name, and then offers them a greeting. What I'm trying to
do is take the user name and turn it into thier real name. I only have
about 5 people that use this workbook. So I'd like jdoe1 to be John Doe
1, and jdoe2 to be John Doe 2, etc. I can't seem to get it to work for
multiple persons.

=IF(NOW()-INT(NOW())<0.5,"Good Morning"&" "&GetName(2)&"Today is"&"
"&TEXT(TODAY(),"mmmm dd, yyyy"),IF(NOW()-INT(NOW())<0.75,"Good
Afternoon"&" "&GetName(2)&"Today is"&" "&TEXT(TODAY(),"mmmm dd,
yyyy"),"Good Evening"&" "&GetName(2)&"Today is"&" "&TEXT(TODAY(),"mmmm
dd, yyyy")))

Thanks in advance.

ep

 

[Bob Phillips]

You don't show GetName, but I assume it is a simple function to return the
user name, and with such a function it worked fine for me.

I simplified it though like so

="Good
"&LOOKUP(MOD(NOW(),1),{0,0.5,0.75},{"Morning","Afeternoon","Evening"})&GetNa
me(2)&"Today is"&" "&TEXT(TODAY(),"mmmm dd, yyyy")

The other thing to note is that it will not update as the time changes,
unless some othe calc happens.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"edwardpestian" <[email protected]>
wrote in message
news:[email protected]...

 

[edwardpestian]

How do I convert their username to their real name. Let's say that
put each user's real name in a cell range: A1:A3. If the username i
jdoe1 then return A1, if the username is jdoe2, then return A2, etc.

A1 = John Doe 1
A2 = John Doe 2
A3 = John Doe 3

Thanks.

e

 

[edwardpestian]

="Good"&
"&LOOKUP(MOD(NOW(),1),{0,0.5,0.75},{"Morning","Afternoon","Evening"})&
"&IF(GetName(2)="jdoe1","John Doe 1"&" "&"Today is"&
"&TEXT(TODAY(),"mmmm dd, yyyy"),IF(GetName(2)="jdoe2","John Doe 2"&
"&"Today is"&" "&TEXT(TODAY(),"mmmm dd
yyyy"),IF(GetName(2)="jdoe3","John Doe 3"&" "&"Today is"&
"&TEXT(TODAY(),"mmmm dd, yyyy"),"Today is"&" "&TEXT(TODAY(),"mmmm dd
yyyy"))))

Is there a better way so that I could add more that 7 users and not b
limited to 7 nested IF statements.

Thanks.

e

 

[Bob Phillips]

Create a lookup table like so

A1 = jdoe1 B1 = John Doe 1
etc., and then use

="Good"&
LOOKUP(MOD(NOW(),1),{0,0.5,0.75},{"Morning","Afeternoon","Evening"})&
VLOOKUP(GetName(2),A1:B10.2,False)&
"Today is"&" "&TEXT(TODAY(),"mmmm dd, yyyy")


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"edwardpestian" <[email protected]>
wrote in message
news:[email protected]...

 

[edwardpestian]

Worked Great. Thanks Bob!