<div>
Very fast response. &nbsp;Thank you.
</div>


<div>
Thanks<br />
<br />
Note that the suggested formula will also allow decimals like 6.34 (because that's between 1 and 25) . If you only want integers change to<br />
<br />
=IF(C6=&quot;X&quot;,TRUE,AND(C6&gt;=1,<wbr />C6&lt;=25,C6-<wbr />INT(C6)=0)<wbr />)<br />
<br />
regards, barry
</div>


Thanks

Note that the suggested formula will also allow decimals like 6.34 (because that's between 1 and 25) . If you only want integers change to

=IF(C6="X",TRUE,AND(C6>=1,C6<=25,C6-INT(C6)=0))

regards, barry

<div>
Just want whole numbers to be entered so would your second formula be better for that.<br />

</div>


Just want whole numbers to be entered so would your second formula be better for that.


<div>
Yes, second version will allow integers only<br />
<br />
regards, barry
</div>


Yes, second version will allow integers only

regards, barry

<div>
<div class="content wysiwyg-content">
Want to validate cells C6 through V300 so only the letter X (capital or lowercase) or a number between 1 and &nbsp;25 can be entered in the cell. &nbsp;Trying to figure out a custom formula for this. &nbsp;Thank you.<br />

</div>
</div>


Want to validate cells C6 through V300 so only the letter X (capital or lowercase) or a number between 1 and  25 can be entered in the cell.  Trying to figure out a custom formula for this.  Thank you.


Want to validate cells to only have a letter X or a number between 1 and 25

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.