'if' a cell is not having data show it as blank... How?

**nawshotBO** · 12-10-2008, 04:50 AM

Hi,

my requiremnet is, there is data going to excel from database. The data is something like jan to dec sales and in a arbitrary fashion. now if there wont be data availble for say month of july then nothing will be there.
Now i need to nicely formulate data from jan feb ..Dec and in same order in another cells. Now for empty cells data after formualting it is coming as #N/A. and by this i am getting a same thing in the application where this excel sheet is being used. So for eliminating it i need to use 'if' such that if it is undefined or NULL then blank should be there in the formulated cell.

So wht is the synataxed to be used with 'if' for this.

pls Help

regards,
Naresh Elugala.

**Shijesh Kumar** · 12-10-2008, 04:57 AM

Hi,

U can use ISERROR in combination with IF function to get rid of #N/A

eg. if you are using vlookup then syntax will be

Please Login or Register  to view this content.

**Steve R** · 12-10-2008, 04:59 AM

=if(iserror(a1),"",a1)

**nawshotBO** · 12-10-2008, 05:09 AM

Thanks for ur reply. But i forgot to mention one thing, iserror is NOT supported by the application whr it is used.

**arthurbr** · 12-10-2008, 05:17 AM

You are not using XL then?

**nawshotBO** · 12-10-2008, 05:46 AM

Its not that way. we use this excel sheet in another application called Xcelsius.

**martindwilson** · 12-10-2008, 06:31 AM

try an xcelcius forum then! how are we supposed to guess what is and isnt used in another programme.
=if(iserror(a1),"",a1) works fine in excel
but doesnt work too well in mspaint.

**nawshotBO** · 12-10-2008, 07:22 AM

These are all functions supported by the appliction:
ABS ACOS ACOSH AND ASIN
ASINH ASSIGN ATAN ATAN2 ATANH
AVEDEV AVERAGE AVERAGEA BETADIST CEILING
CHOOSE COMBIN CONCATENATE COS COSH
COUNT COUNTA COUNTIF DATE DATEVALUE
DAVERAGE DAY DAYS360 DB DCOUNT
DCOUNTA DDB DEGREES DEVSQ DGET
DIVIDE DMAX DMIN DOLLAR DPRODUCT
DSTDEV DSTDEVP DSUM DVAR DVARP
EDATE EOMONTH EVEN EXACT EXP
EXPONDIST FACT FALSE FIND FISHER
FISHERINV FIXED FLOOR FORECAST FV
GE GEOMEAN GT HARMEAN HLOOKUP
HOUR IF INDEX INT INTERCEPT
IPMT IRR ISBLANK KURT LARGE
LE LEFT LEN LN LOG
LOG10 LOOKUP LOWER MATCH MAX
MEDIAN MID MIN MINUS MINUTE
MIRR MOD MODE MONTH N
NE NETWORKDAYS NORMDIST NORMINV NORMSINV
NOT NOW NPER NPV OFFSET
OR PI PMT POWER PPMT
PRODUCT PV QUOTIENT RADIANS RAND
RANGE_COLON RANK RATE REPLACE REPT
RIGHT ROUND ROUNDDOWN ROUNDUP SECOND
SIGN SIN SINH SLN SMALL
SQRT STANDARDIZE STDEV SUM SUMIF
SUMPRODUCT SUMSQ SUMX2MY2 SUMX2PY2
SUMXMY2 SYD TAN TANH TEXT
TIME TIMEVALUE TODAY TRUE TRUNC
UPPER VALUE VAR VDB VLOOKUP