Change the "false" to "future"?

[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.........

[Dave Peterson]

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

or maybe:

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



BruceM wrote:
>
> 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.........

--

Dave Peterson

[BruceM]

Thankyou Dave



"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> if(a1<>0,sum(x1:x99),"Future")
>
> or maybe:
>
> =if(sum(x1:x99)<>0,sum(x1:x99),"Future")
>
>
>
> BruceM wrote:
>>
>> 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.........
>
> --
>
> Dave Peterson