Change the "false" to "future"?

  • Thread starter Thread starter BruceM
  • Start date Start date
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.........
 
if(a1<>0,sum(x1:x99),"Future")

or maybe:

=if(sum(x1:x99)<>0,sum(x1:x99),"Future")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble flagging conditions in Excel using VB 6
Excel How to get output of the formula instead of True or false 1
Excel formula, sum the value cell and if empty cell left blank 0
Formula nesting with IF statements 2
Help with VBA to find data delete it change font, add lines then looptill end of file 4
How to set cell value to emptry if three other columns are empty too 1
False value 3
loop until empty row and column problem (format cells until the lastrow and column in a report) 2

Back
Top