Return Value

E

Eileen

I use a formuluar and return "" for A1, C1(=A1+B1)will be
#value!. Is there a way I can return A1 as empty cell
instead of blank that C1 can be automatially calculated?
By the way, I perfer not to show A1 as 0, or there is a
way I can hide it.

My goal is eliminate #n/a in vlookups and have other
formular that depend on A1 works!

Please help !
 
M

Myrna Larson

In C1, use the formula =SUM(A1:B1). Sum ignores text entries. The addition
operator (the plus sign, +), doesn't.
 
F

flkulchar

Use:

Either...
IF(yourformula=0,"",yourformula)

or...

IF(COUNT(RANGE)=0,"",COUNTIF(BA8,CRITERION)+COUNTIF
(BC8,CRITERION)+COUNTIF(BE8,CRITERION)
 
Top