Forum Discussion

rogermon's avatar
rogermon
Copper Contributor
Oct 17, 2022
Solved

A help with IF formula

HI, my first post!.  I have a cell A:1 where i put in a letter ( A or B), depended of what letter i put in A:1, i am trying to get a grand total in a cell (B:1 for the argument) to either multiply a...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Oct 17, 2022

    rogermon 

    =IF(A1="A",B1*3,IF(A1="B",B1*4,""))

    Maybe with a nested IF formula.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Oct 17, 2022

rogermon 

=IF(A1="A",B1*3,IF(A1="B",B1*4,""))

Maybe with a nested IF formula.

 

  • rogermon's avatar
    rogermon
    Copper Contributor
    Oct 18, 2022

    OliverScheurich That did the trick! thank you for a quick answer. 

     

  • BrentP2020's avatar
    BrentP2020
    Copper Contributor
    Oct 17, 2022
    rogermon
    Just in case you're confused, as I was. 🙂
    Note the formula in the picture shows WENN, which is IF in German.

Resources