Please help with dashes


D

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))
 
Ad

Advertisements

K

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)
 
D

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. :(
 
Ad

Advertisements


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

Top