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


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

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","Afe ternoon","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"
wrote in message
news:edwardpestian.29wgbb_1151140802.4986@excelfor um-nospam.com...

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


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

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

--
edwardpestia
-----------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...fo&userid=3380
View this thread: http://www.excelforum.com/showthread.php?threadid=55519

="Good"&
"&LOOKUP(MOD(NOW(),1),{0,0.5,0.75},{"Morning","Aft ernoon","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

--
edwardpestia
-----------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...fo&userid=3380
View this thread: http://www.excelforum.com/showthread.php?threadid=55519

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","Afete rnoon","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"
wrote in message
news:edwardpestian.29wnhn_1151150102.687@excelforu m-nospam.com...

How do I convert their username to their real name. Let's say that I
put each user's real name in a cell range: A1:A3. If the username is
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.

ep


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

Worked Great. Thanks Bob!


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