• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 177
  • Last Modified:

EXCEL FORMULA, IF ELSE HELP

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
0
rutgermons
Asked:
rutgermons
  • 2
1 Solution
 
Santosh GuptaCommented:
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 ?
0
 
Saqib Husain, SyedEngineerCommented:
=if(C$3="","",RIGHT(C$3,LEN(C$3)-15)&B36)
0
 
Santosh GuptaCommented:
=IF(C$3="","NULL",RIGHT(C$3,LEN(C$3)-15)&B36)
0
 
Rob HensonFinance AnalystCommented:
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
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now