EXCEL FORMULA, IF ELSE HELP

rutgermons
rutgermons used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2014

Commented:
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 ?
=if(C$3="","",RIGHT(C$3,LEN(C$3)-15)&B36)
Top Expert 2014
Commented:
=IF(C$3="","NULL",RIGHT(C$3,LEN(C$3)-15)&B36)
Rob HensonFinance Analyst

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial