multiple if's regarding LEFT function

[avandever]

i have two columns that i want to concatenate but in the 2nd column, some numbers are 1.9, 2.9, 3.9, etc.. all the way to 24.9. i want to concat the left columns data along with everything left of the "." in the second column. Here is the formula i have and all it does is return blanks. thanks.

<table border="0" cellpadding="0" cellspacing="0" width="148"><col style="width: 61pt;" width="81"> <col style="width: 50pt;" width="67"> <tbody><tr style="height: 15pt;" height="20"> <td style="height: 15pt; width: 61pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(220, 230, 241);" height="20" width="81">sonum</td> <td style="width: 50pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215); background: none repeat scroll 0% 0% rgb(220, 230, 241);" width="67">lnnum</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" height="20">A237279</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" align="right">1.9</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" height="20">A278143</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" align="right">3.9</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" height="20">A910076</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" align="right">11.9</td> </tr> <tr style="height: 15pt;" height="20"> <td style="height: 15pt; font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri; border-width: medium medium 0.5pt; border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color rgb(149, 179, 215);" height="20">A276435</td> <td style="font-size: 11pt; color: black; font-weight: 700; text-decoration: none; font-family: Calibri;" align="right">14.9</td> </tr> </tbody></table>
=IF(LEFT(B3,2)=".",A3&LEFT(B3,1),IF(LEFT(B3,3)=".",A3&LEFT(B3,2),""))

 

[Jonmo1]

Try

=A3&INT(B3)


Hope that helps.

 

[avandever]

that did it. i need to start thinking simple!

 

[Jonmo1]

I wouldn't say think "simple"
Just avoid over complicating...

There's a fine line between
Simple and just "not complicated"