S
sarah
This is my current formula:
=((Z6+(IF(C6="P",(AB$41+AB$27),IF(C6="B",(AB$48+AB$118),IF(C6="T",(AB$43+AB$18),IF(C6="DT",(AB$8+AB$18),IF(C6="ST",(AB$49+AB$119),IF(C6="AT1",(AB$30+AB$6),IF(C6="AT2",(AB$28+AB$11),IF(C6="DC",(AB$30+AB$11+AB$119),0)))))))))))
I need to add one more if function in this formula. What is the recommended
formula i should use. I would love to put this in a macro but not sure how i
should go about doing this.
Please advise
=((Z6+(IF(C6="P",(AB$41+AB$27),IF(C6="B",(AB$48+AB$118),IF(C6="T",(AB$43+AB$18),IF(C6="DT",(AB$8+AB$18),IF(C6="ST",(AB$49+AB$119),IF(C6="AT1",(AB$30+AB$6),IF(C6="AT2",(AB$28+AB$11),IF(C6="DC",(AB$30+AB$11+AB$119),0)))))))))))
I need to add one more if function in this formula. What is the recommended
formula i should use. I would love to put this in a macro but not sure how i
should go about doing this.
Please advise