Solved

EXCEL FORMULA, IF ELSE HELP

Posted on 2014-03-06
143 Views
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
Question by:rutgermons
• 2

LVL 13

Expert Comment

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

LVL 43

Expert Comment

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

LVL 13

Accepted Solution

Santosh Gupta earned 500 total points
=IF(C\$3="","NULL",RIGHT(C\$3,LEN(C\$3)-15)&B36)
0

LVL 31

Expert Comment

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

Featured Post

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…