vendredi 28 novembre 2014

Same question but different column names



Im sorry for bothering you again but when I tried the same formula but different column names it did not work... Column names for example are: F1 Makeup (26),F1 bridge tap (26),F2 bridge tap (26),F1 Makeup (26), f1 makeup(22), ETC Just for your reference)


below is the calculation that didn't work when I clicked save...


=IF([Circuit Type]="ISDN",(([F1 Makeup (26)] + [F1 bridge tap (26)] + [F2 Makeup (26)] + [F2 bridge tap (26)]) * 2.81) + (([F1 Makeup (24)] + [F1 bridge tap (24)] + [F2 Makeup (24)] + [F2 bridge tap (24)]) * 2.03) + (([F1 Makeup (22)] + [F1 bridge tap (22)] + [F2 Makeup (22)] + [F2 bridge tap (22)]) * 1.42) + (([F1 Makeup (19)] + [F1 bridge tap (19)] + [F2 Makeup (19)] + [F2 bridge tap (19)]) * 0.84),IF([Circuit Type]="56",(([F1 Makeup (26)] + [F1 bridge tap (26)] + [F2 Makeup (26)] + [F2 bridge tap (26)]) * 2.45) + (([F1 Makeup (24)] + [F1 bridge tap (24)] + [F2 Makeup (24)] + [F2 bridge tap (24)]) * 1.85) + (([F1 Makeup (22)] + [F1 bridge tap (22)] + [F2 Makeup (22)] + [F2 bridge tap (22)]) * 1.3) + (([F1 Makeup (19)] + [F1 bridge tap (19)] + [F2 Makeup (19)] + [F2 bridge tap (19)]) * 0.77),IF([Circuit Type]="19.2",(([F1 Makeup (26)] + [F1 bridge tap (26)] + [F2 Makeup (26)] + [F2 bridge tap (26)]) * 1.73) + (([F1 Makeup (24)] + [F1 bridge tap (24)] + [F2 Makeup (24)] + [F2 bridge tap (24)]) * 1.31) + (([F1 Makeup (22)] + [F1 bridge tap (22)] + [F2 Makeup (22)] + [F2 bridge tap (22)]) * 0.96) + (([F1 Makeup (19)] + [F1 bridge tap (19)] + [F2 Makeup (19)] + [F2 bridge tap (19)]) * 0.59),IF([Circuit Type]="DDS T.R",(([F1 Makeup (26)] + [F1 bridge tap (26)] + [F2 Makeup (26)] + [F2 bridge tap (26)]) * 1.91) + (([F1 Makeup (24)] + [F1 bridge tap (24)] + [F2 Makeup (24)] + [F2 bridge tap (24)]) * 1.46) + (([F1 Makeup (22)] + [F1 bridge tap (22)] + [F2 Makeup (226)] + [F2 bridge tap (22)]) * 1.08) + (([F1 Makeup (19)] + [F1 bridge tap (19)] + [F2 Makeup (19)] + [F2 bridge tap (19)]) * 0.64),IF([Circuit Type]="HDSL",(([ F1 Makeup (26)] + [F2 Makeup (26)]) * 3.88 + (([F1 Makeup (24)] + [F2 Makeup (24)]) * 2.84) + (([F1 Makeup (22)] + [F2 Makeup (22)]) * 2.18) + (([F1 Makeup (19)] + [F2 Makeup (19)]) * 1.5) + (([Num of F1 BTs + Num of F2 BTs]) * 3) + [Num of F1 Guage changes (HDSL)] + [Num of F2 Guage changes (HDSL)]),0)))))








0 commentaires:

Enregistrer un commentaire