Forum Discussion

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
Oct 17, 2022
rogermon
=IF(A1="A",B1*3,IF(A1="B",B1*4,""))
Maybe with a nested IF formula.

OliverScheurich

Gold Contributor

Oct 17, 2022

rogermon

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

Maybe with a nested IF formula.

rogermon

Copper Contributor

Oct 18, 2022

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