Change the "false" to "future"?

B

BruceM

In formula,
Test if <>0 then do sum,
If it is in fact "0", then the result is "false",
Can I have it report "future" or even just "0" instead? How?
Do I need 2 "ifs"?

Thankyou.........
 
D

Dave Peterson

if(a1<>0,sum(x1:x99),"Future")

or maybe:

=if(sum(x1:x99)<>0,sum(x1:x99),"Future")
 
Top