Please help with dashes

[Debbie]

I want nothing to appear if the value is zero, but it
there is a value, I want the value PLUS a dash. Any
suggestions?

=CONCATENATE(IF(D12=0,"",D12),IF(D12>0,+"-",D12),IF

(E12=0,"",E12),IF(E12>0,+"-",E12),IF(F12=0,"",F12),IF
(F12>0,+"-",F12),IF(G12=0,"",G12),IF(G12>0,+"-",G12),IF
(H12=0,"",H12),IF(H12>0,+"-",H12),IF(I12=0,"",I12),IF
(I12>0,+"-",I12),IF(J12=0,"",J12),IF(J12>0,+"-",J12),IF
(K12=0,"",K12),(K12>0,+"-",K12),IF(L12=0,"",L12),(K12>0,+"-
",K12),IF(M12=0,"",M12),(M12>0,+"-",M12),IF(N12=0,"",N12),
(N12>0,+"-",N12),IF(O12=0,"",O12),(O12>0,+"-",O12),IF
(P12=0,"",P12),(P12>0,+"-",P12))

 

[keyt]

You have to give it an alternative to the zeroes.

Your IF statement requires a IF TRUE and IF FALSE.

IF(something is something , then do this, if not do this)

 

[Debbie]

Keyt
I thought the formula below gave an alternative. If D12=0
leave it blank, and if D12>0 give the value and a dash.
Sorry, but I am confused.

 

[J.E. McGimpsey]

you could try extending the solution I gave you yesterday:

http://google.com/groups?threadm=jemcgimpsey-B34499.14051930092003@
news.uswest.net

 

[Debbie]

Thanks for your help!

-----Original Message-----
you could try extending the solution I gave you yesterday:

http://google.com/groups?threadm=jemcgimpsey- B34499.14051930092003%40
news.uswest.net



.