robert0803
Board Regular
- Joined
- Aug 3, 2005
- Messages
- 115
I tried but I am not sure what I am missing.
Formula is in S1. I need it to look in P1 and IF it has a value of 1-25 I need S1 to state the text in Q1 AND (1-25), (26-75),(76-150), or (over 150).
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>Splits</th><th>BatchRngSize</th><th>DOW</th><th>BatchRngSplits</th></tr></thead><tbody>
<tr><td>1</td><td>4K to 8K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "4K to 8K (1-25)"</td></tr>
<tr><td>1</td><td>Under 2K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "Under 2K (1-25)"</td></tr>
<tr><td>36</td><td>Under 2K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "Under 2K (26-75)"</td></tr>
<tr><td>129</td><td>Under 2K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "Under 2K (76-150)"</td></tr>
<tr><td>351</td><td>Under 2K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "Under 2K over 150"</td></tr>
<tr><td>58</td><td>2K to 4K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "2K to 4K (26-75)"</td></tr>
</tbody></table>
Formula is in S1. I need it to look in P1 and IF it has a value of 1-25 I need S1 to state the text in Q1 AND (1-25), (26-75),(76-150), or (over 150).
<style type="text/css">
table.tableizer-table {
font-size: 12px;
border: 1px solid #CCC;
font-family: Arial, Helvetica, sans-serif;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #CCC;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style>
<table class="tableizer-table">
<thead><tr class="tableizer-firstrow"><th>Splits</th><th>BatchRngSize</th><th>DOW</th><th>BatchRngSplits</th></tr></thead><tbody>
<tr><td>1</td><td>4K to 8K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "4K to 8K (1-25)"</td></tr>
<tr><td>1</td><td>Under 2K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "Under 2K (1-25)"</td></tr>
<tr><td>36</td><td>Under 2K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "Under 2K (26-75)"</td></tr>
<tr><td>129</td><td>Under 2K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "Under 2K (76-150)"</td></tr>
<tr><td>351</td><td>Under 2K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "Under 2K over 150"</td></tr>
<tr><td>58</td><td>2K to 4K</td><td> Wednesday</td><td> =IF STATEMENT should pull data to say "2K to 4K (26-75)"</td></tr>
</tbody></table>