[mso] Re: CONCATENATE doesn't work Why? Thanks
- From: Donald Smith <dcsmith@xxxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 5 Nov 2003 19:47:23 GMT
I used this formula but now I end up with the correct figure followed by 6
zeros. For example:
4.37000000
when it should be 4.37
Thanks Again
Gets very frustrating. I read through all the information and I don't see
where I went wrong
Thanks
Don
FORMULA:
=CONCATENATE(IF(B13="1001-18A",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),0),IF(B13="1001-90",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),0),IF(B13="1102-055",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),0),IF(B13="1102-330",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),0),IF(B13="552-055",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),0),IF(B13="751-055",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),0),IF(B13="1106-055",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),0))
LINDA SAID:
Here's some alternatives to when you need more than seven nested IFs....
http://j-walk.com/ss/excel/usertips/tip080.htm
> Wellllll it looks like Excel just can't do what I need it to do.
> Thanks for pointing that out wasn't aware of the lucky seven limitation,
> anyway, must be I am the only one that ever has more than lucky seven
> conditions, makes me wonder if someone at MS spent tooo much time in Vegas.
> Thanks Again
> Don
>
>
>
> [mso] Re: VLOOKUP doesn't work Why? Thanks
>
> * To: <mso@xxxxxxxxxxxxx>
> * Subject: [mso] Re: VLOOKUP doesn't work Why? Thanks
> * From: "Linda F. Johnson" <linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
> * Date: Wed, 5 Nov 2003 11:00:45 -0500
>
> You can only nest 7 IFs...it looks to me like you have about 12 in there
>
>
> Linda F. Johnson, M.A., MOS
> Linda's Computer Stop
> http://personal-computer-tutor.com
> Free e-Books, Newsletter, and tutorials
>
>
> -----Original Message-----
> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On Behalf
> Of Donald Smith
> Sent: Wednesday, November 05, 2003 9:54 AM
> To: mso@xxxxxxxxxxxxx
> Subject: [mso] VLOOKUP doesn't work Why? Thanks
>
> =IF(B2="1001-18A",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),IF(B2="1001-90",VL
> OOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),IF(B2="1001-B",VLOOKUP($B$32,'zz-Hourl
> y'!$A$1:$G$79,7),IF(B2="1001-F",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),IF(B
> 2="1001-H",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),IF(B2="1001-S",VLOOKUP($B
> $32,'zz-Hourly'!$A$1:$G$79,7),,IF(B2="1001-V",VLOOKUP($B$32,'zz-Hourly'!$A$1
> :$G$79,7),IF(B2="1102-055",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),IF(B2="11
> 02-330",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),IF(B2="552-055",VLOOKUP($B$3
> 2,'zz-Hourly'!$A$1:$G$79,7),IF(B2="751-055",VLOOKUP($B$32,'zz-Hourly'!$A$1:$
> G$79,7),IF(B2="1106-055",VLOOKUP($B$32,'zz-Hourly'!$A$1:$G$79,7),0))))))))))
> ))
>
> Can someone take a look at this and tell me why it doesn't work Thanks Don
>
>
> *************************************************************
> ---------------------------------------------
> This message was sent using Road Runner's Web-based
e-mail.
---------------------------------------------
This message was sent using Road Runner's Web-based
e-mail.
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
