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?
(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))
there is a value, I want the value PLUS a dash. Any
suggestions?
(E12=0,"",E12),IF(E12>0,+"-",E12),IF(F12=0,"",F12),IF=CONCATENATE(IF(D12=0,"",D12),IF(D12>0,+"-",D12),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))