keep bllank cells blank

[Rudy]

my table has columns with formulas. some of the rows are
blank. the formulas do not apply to the blank rows. in
some of the colums, in blank cells a zero prints and in
other columns a $ sign prints in empty cells , and others
get "#value!" while some remain empty.

my question is this - if there is no data, I would like
the cells to remain blank. how do I accomplish this?

 

[Frank Kabel]

Hi
what are the exact formulas you're using?

 

[Guest]

i have a few different formulas in a few different
columns. most are "=sum" and one is an "if".

i hope i understood your question

 

[Frank Kabel]

Hi
the reason I asked for your formulas ´was to check if they return some
spaces or other invisible characters

So you may post an exmaple of your IF formulas (the complete one
please)

 

[rudy]

i'm sorry i didn't understand your question, but i do now.

here is one of the formulas.....

=A1+C1

and the column is set to currency format. it is entering
a $ . in the column if a and c are blank. I would like
it just keeps the cell blank if there is no data in a
and c. is this possible?

the if formula is ........

IF(F1="X",100,IF(F1="Y",150,IF(F1="Z",200,"")))

and it is entering #value! in the cell if f1 is empty.
if there is either an x, y or z in f1, then it puts in
the correct answer

 

[Frank Kabel]

Hi
for your first formula you may use:
=IF(COUNTA(A1,C1)=0,"",A1+C1)

Your second formula should not return #VALUE. The only reason for this
error could be that cell F1 itself comtains this #VALUE error