Need Help: Ultimate IF/AND Statement

[dmcone]

Can someone help me write an IF/AND statement with the following conditions:

<table border="0" cellpadding="0" cellspacing="0" width="528"><col style="width: 396pt;" width="528"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; width: 396pt;" width="528" height="17">If less than or equal to 10% but greater than 2% then express to nearest 2% increment.</td> </tr> <tr style="height: 15.75pt;" height="21"> <td class="xl63" style="height: 15.75pt; border-top: medium none;" height="21">If between 10 and 50% then express to nearest 5% increment.</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">If greater than 50% then express to nearest 10% increment.</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">If less than 2% but greater or equal to 1% then = 2%. </td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl63" style="height: 12.75pt; border-top: medium none;" height="17">If less than 1% then = 0.</td> </tr> </tbody></table>
I have spent hours on it and keep getting back too many arguments. Thanks if anyone accepts the challenge

 

[Oaktree]

Welcome to the board!

Try:

=CHOOSE((A2<1%)*1+AND(A2>=1%,A2<2%)*2+AND(A2>=2%,A2<=10%)*3+AND(A2>10%,A2<=50%)*4+(A2>50%)*5,0,2%,MROUND(A2,2%),MROUND(A2,5%),MROUND(A2,10%))

Note that MROUND requires the analysis toolpak add-in.

 

[markmzz]

Maybe this (two formulas - choose one):

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">Value</td><td style="font-weight: bold;text-align: center;;">Form1</td><td style="font-weight: bold;text-align: center;;">Form2</td><td style="text-align: right;;"></td><td style="text-align: right;;">0%</td><td style="text-align: right;;">0%</td><td style="text-align: center;;">Case5</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0%</td><td style="text-align: right;;">0%</td><td style="text-align: right;;"></td><td style="text-align: right;;">1%</td><td style="text-align: right;;">2%</td><td style="text-align: center;;">Case1&Case4</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">0.90%</td><td style="text-align: right;;">0%</td><td style="text-align: right;;">0%</td><td style="text-align: right;;"></td><td style="text-align: right;;">10.01%</td><td style="text-align: right;;">5%</td><td style="text-align: center;;">Case2</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">1.00%</td><td style="text-align: right;;">2%</td><td style="text-align: right;;">2%</td><td style="text-align: right;;"></td><td style="text-align: right;;">50.01%</td><td style="text-align: right;;">10%</td><td style="text-align: center;;">Case3</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">10.00%</td><td style="text-align: right;;">2%</td><td style="text-align: right;;">2%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">10.01%</td><td style="text-align: right;;">5%</td><td style="text-align: right;;">5%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">50.00%</td><td style="text-align: right;;">5%</td><td style="text-align: right;;">5%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">50.01%</td><td style="text-align: right;;">10%</td><td style="text-align: right;;">10%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet2</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B2</th><td style="text-align:left">=LOOKUP(<font color="Blue">A2,{0,0;0.01,0.02;0.1001,0.05;0.5001,0.1}</font>)</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C2</th><td style="text-align:left">=LOOKUP(<font color="Blue">A2,E$1:F$4</font>)</td></tr></tbody></table></td></tr></table><br />
Markmzz

 

[dmcone]

thanks for your help. I tried your formula and got the exact same thing that was in the linked cell. any other ideas?

 

[markmzz]

Or this:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">Value</td><td style="font-weight: bold;text-align: center;;">Form</td><td style="text-align: right;;"></td><td style="text-align: right;;">0%</td><td style="text-align: right;;">0%</td><td style="text-align: center;;">Case5=</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0%</td><td style="text-align: right;;"></td><td style="text-align: right;;">1%</td><td style="text-align: right;;">2%</td><td style="text-align: center;;">Case4=</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">1.00%</td><td style="text-align: right;;">2%</td><td style="text-align: right;;"></td><td style="text-align: right;;">2.01%</td><td style="text-align: right;;">2%</td><td style="text-align: center;;">Case1</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">3.00%</td><td style="text-align: right;;">4%</td><td style="text-align: right;;"></td><td style="text-align: right;;">10.01%</td><td style="text-align: right;;">5%</td><td style="text-align: center;;">Case2</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">7.00%</td><td style="text-align: right;;">8%</td><td style="text-align: right;;"></td><td style="text-align: right;;">50.01%</td><td style="text-align: right;;">10%</td><td style="text-align: center;;">Case3</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">11.00%</td><td style="text-align: right;;">10%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">13.00%</td><td style="text-align: right;;">15%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">55.00%</td><td style="text-align: right;;">60%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td></tr></tbody></table><p style="width:4.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet21</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B2</th><td style="text-align:left">=IF(<font color="Blue">A2<=2%,LOOKUP(<font color="Red">A2,D$1:E$5</font>),MROUND(<font color="Red">A2,LOOKUP(<font color="Green">A2,D$1:E$5</font>)</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
Markmzz

 

[Oaktree]

What do you mean "the exact same thing that was in the linked cell"?

Did you use my formula or (either of) Markmzz's?

Note the limitation of the LOOKUP approach for values such as -10% or 10.00001%. May or not be an issue for your use.

 

[dmcone]

I used yours. And the result I got was just what ever was in A2.

No clue what the other dude is even doing. I appreciate it though

I thought I could just put it into an IF statement with a bunch of and conditions and it would work, but I am having trouble

 

[markmzz]

Dmcone,

Did you try this formula?

If yes, post the results here.

To post your data, put borders around a small range of the cells.

Then copy the range, and paste them here.

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;text-align: center;;">Value</td><td style="font-weight: bold;text-align: center;;">Form</td><td style="text-align: right;;"></td><td style="text-align: right;;">0%</td><td style="text-align: right;;">0%</td><td style="text-align: center;;">Case5=</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">0.00%</td><td style="text-align: right;;">0%</td><td style="text-align: right;;"></td><td style="text-align: right;;">1%</td><td style="text-align: right;;">2%</td><td style="text-align: center;;">Case4=</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">0.90%</td><td style="text-align: right;;">0%</td><td style="text-align: right;;"></td><td style="text-align: right;;">2.01%</td><td style="text-align: right;;">2%</td><td style="text-align: center;;">Case1</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">1.00%</td><td style="text-align: right;;">2%</td><td style="text-align: right;;"></td><td style="text-align: right;;">10.01%</td><td style="text-align: right;;">5%</td><td style="text-align: center;;">Case2</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">2.00%</td><td style="text-align: right;;">2%</td><td style="text-align: right;;"></td><td style="text-align: right;;">50.01%</td><td style="text-align: right;;">10%</td><td style="text-align: center;;">Case3</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">2.01%</td><td style="text-align: right;;">2%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">3.00%</td><td style="text-align: right;;">4%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">4.00%</td><td style="text-align: right;;">4%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">5.00%</td><td style="text-align: right;;">6%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">7.00%</td><td style="text-align: right;;">8%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">9.00%</td><td style="text-align: right;;">10%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">10.00%</td><td style="text-align: right;;">10%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">10.01%</td><td style="text-align: right;;">10%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">13.00%</td><td style="text-align: right;;">15%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">21.00%</td><td style="text-align: right;;">20%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">22.00%</td><td style="text-align: right;;">20%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">23.00%</td><td style="text-align: right;;">25%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">50.00%</td><td style="text-align: right;;">50%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">54.00%</td><td style="text-align: right;;">50%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">55.00%</td><td style="text-align: right;;">60%</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td><td style=";">*******</td></tr></tbody></table><p style="width:4.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet21</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B2</th><td style="text-align:left">=IF(<font color="Blue">A2<=2%,LOOKUP(<font color="Red">A2,D$1:E$5</font>),MROUND(<font color="Red">A2,LOOKUP(<font color="Green">A2,D$1:E$5</font>)</font>)</font>)</td></tr></tbody></table></td></tr></table><br />
Markmzz

 

[Oaktree]

I used yours. And the result I got was just what ever was in A2.

What input/test values did you use? Seems to be working as desired per the below:

<b>Excel 2002</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Input</td><td style=";">Returned</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">-0.8%</td><td style="text-align: right;;">0.0%</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;;">0.0%</td><td style="text-align: right;;">0.0%</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;;">0.8%</td><td style="text-align: right;;">0.0%</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">1.6%</td><td style="text-align: right;;">2.0%</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">2.4%</td><td style="text-align: right;;">2.0%</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: right;;">3.2%</td><td style="text-align: right;;">4.0%</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;">4.0%</td><td style="text-align: right;;">4.0%</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;">4.8%</td><td style="text-align: right;;">4.0%</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;">5.6%</td><td style="text-align: right;;">6.0%</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;">6.4%</td><td style="text-align: right;;">6.0%</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;">7.2%</td><td style="text-align: right;;">8.0%</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;">8.0%</td><td style="text-align: right;;">8.0%</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;">8.8%</td><td style="text-align: right;;">8.0%</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;">9.6%</td><td style="text-align: right;;">10.0%</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;">10.4%</td><td style="text-align: right;;">10.0%</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;">11.2%</td><td style="text-align: right;;">10.0%</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;">12.0%</td><td style="text-align: right;;">10.0%</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;">12.8%</td><td style="text-align: right;;">15.0%</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;">13.6%</td><td style="text-align: right;;">15.0%</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;">14.4%</td><td style="text-align: right;;">15.0%</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;">15.2%</td><td style="text-align: right;;">15.0%</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;">16.0%</td><td style="text-align: right;;">15.0%</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;">16.8%</td><td style="text-align: right;;">15.0%</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;">17.6%</td><td style="text-align: right;;">20.0%</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;">18.4%</td><td style="text-align: right;;">20.0%</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;">19.2%</td><td style="text-align: right;;">20.0%</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />

 

[dmcone]

Tried .8 and got back .8. Not sure what I am doing wrong

Mark, you're still way over my head bro