Forum Discussion

QueenieMak_qmsy's avatar
QueenieMak_qmsy
Copper Contributor
Jan 26, 2022
Solved

Excel formula Combination

Hi I would like to combine the below 5 formulas in 1 formula, how could i do it?   Item No. of date Formula A 14 IF(I10="A",14,0) Z 17 IF(I11="Z",17,0) J 70 IF(I12="J",70,0) ...
excel
Formulas and Functions
  • dewandi's avatar
    dewandi
    Jan 27, 2022
    Maybe:

    =IF(I10="A",14,IF(I10="Z",17,IF(I10="j",70,IF(I10="K",25,IF(I10="H",7,0)))))

JMB17's avatar
JMB17
Bronze Contributor
Jan 27, 2022
Perhaps
=Switch(I10, "A", 14, "Z", 17, "J", 70, "K", 25, "H", 7, 0)
  • QueenieMak_qmsy's avatar
    QueenieMak_qmsy
    Copper Contributor
    Jan 27, 2022
    No switch at my excel, tks