<div>
what i understood, if cell C3 is NULL then formula cell will show NULL else if calculate <br />
=RIGHT(C$3,LEN(C$3)-15)&amp;B3<wbr />6<br />
<br />
am i right ?
</div>


what i understood, if cell C3 is NULL then formula cell will show NULL else if calculate
=RIGHT(C$3,LEN(C$3)-15)&B36

am i right ?

<div>
=if(C$3=&quot;&quot;,&quot;&quot;,RIGHT(C$3,LE<wbr />N(C$3)-15)<wbr />&amp;B36)
</div>


=if(C$3="","",RIGHT(C$3,LEN(C$3)-15)&B36)

<div>
Assuming I am interpreting your formula correctly that you want all but the first 15 characters from C3, an alternative formula:<br />
<br />
=IF(C$3=&quot;&quot;,&quot;&quot;,MID(C$3,16,L<wbr />EN(C$3))&amp;B<wbr />36)<br />
<br />
This says, start at character 16 and give the rest of the cell, although LEN(C$3) will always give a result higher than the required number of characters (LEN - 15) it won't return additional characters that aren't there.<br />
<br />
Thanks<br />
Rob
</div>


Assuming I am interpreting your formula correctly that you want all but the first 15 characters from C3, an alternative formula:

=IF(C$3="","",MID(C$3,16,LEN(C$3))&B36)

This says, start at character 16 and give the rest of the cell, although LEN(C$3) will always give a result higher than the required number of characters (LEN - 15) it won't return additional characters that aren't there.

Thanks
Rob

<div>
<div class="content wysiwyg-content">
FOLKS<br />
<br />
<br />
=RIGHT(C$3,LEN(C$3)-15)&amp;B3<wbr />6<br />
<br />
How do I if C$3 is null then specify NULL the field using an IF statement
</div>
</div>


FOLKS


=RIGHT(C$3,LEN(C$3)-15)&B36

How do I if C$3 is null then specify NULL the field using an IF statement

EXCEL FORMULA, IF ELSE HELP

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