IF

[Guest]

In cell F9 I am getting #VALUE! to my IF statement, which is:
=IF(SUM(F3+C9)=0,"",SUM(F3+C9)). I have also tried:
=IF(SUM(F3+C9)"","",SUM(F3+C9)) but with the same error of #VALUE!.

There is a formula in F3, which is:
=IF(C3="","",C3). I have tried:
=IF(C3=0,"",C3), but get the same error of #VALUE!

There is no formula in C9.

There is also nothing in any of the cells, so I was expecting nothing in F9.
Why am I getting #VALUE! ??

Connie

 

[JulieD]

Hi Connie

first
SUM(F3+C9) is redundant use either
SUM(F3,C9)
or simply and probably preferrably ..
F3+C9

secondly i don't understand your formula in F3 - you're saying, if C3
doesn't have anything in it, put nothing, otherwise put whatever is in C3 in
F3 ... surely that's the same thing? so from what i can see below the
formula in F3 can be changed to =C3
if for some reason you need the IF formula in F3, then try =IF(C3="",0,C3)

so then hopefully the formula of
=IF(F3+C9=0,"",F3+C9)

should work for you

 

[Guest]

I think I just got the answer: In both formulas I changed the first sign to
a comma, and =0 instead of ="", so this is one for example:
=IF(SUM(F3,C9)=0,"",SUM(F3+C9))

I don't understand this, but it works.

 

[Guest]

Your formulas seem odd. For instance

=IF(C3="","",C3) should just be =C3

The #VALUE message is because you are trying to add a text value "" to C9,
that Excel treats as having a numeric value of 0.

Unless there's a real need to have no zero values, why are you testing for
them and replacing them with ""?

Try changing the formula mentioned above to just

=C3

Then, if you MUST eliminate the zeros, change your IF to

=IF(F3+C9=0,"",F3+C9)

See if that does the trick. If zeros are OK, just leave it as =F3+C9

You can also either format the cells so zeros don't display, or go to Tools
| Options | View and uncheck Zero Values

Duke