Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |