Forum Discussion

QueenieMak_qmsy's avatar
QueenieMak_qmsy
Copper Contributor
Jan 27, 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)))))

dewandi's avatar
dewandi
Copper Contributor
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)))))

  • QueenieMak_qmsy's avatar
    QueenieMak_qmsy
    Copper Contributor
    Jan 27, 2022
    It’s useful, tks!

Resources