IF Statement with two criterias

[robert0803]

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>

 

[MattH1]

Let me know if this works:

=IF($P1<26,$Q1&" (1-25)",IF($P1<76,$Q1&" (26-75)",IF($P1<151,$Q1&" (76-150)",$Q1&" Over 150")))

 

[Tetra201]

Try this:

=IFERROR(Q1&" "&LOOKUP(P1,{1,26,76,151},{"(1-25)","(26-75)","(76-150)","(over 150)"}),"Out of range")

 

[robert0803]

Let me know if this works:

=IF($P1<26,$Q1&" (1-25)",IF($P1<76,$Q1&" (26-75)",IF($P1<151,$Q1&" (76-150)",$Q1&" Over 150")))

PERFECT!! Thanks!

 

[MattH1]

PERFECT!! Thanks!

No problem!