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

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Connie Martin" wrote in message
...
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