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.

HansVogelaar

MVP

Oct 17, 2022

rogermon

What exactly do you want to multiply with what? Please try to explain more clearly.

rogermon
Copper Contributor
Oct 18, 2022
I got the answer, but i was trying to calculate to different variables, depending on wich letter i put in a cell, Quadruple_Pawn helpd me on the right track. Thanks all for helping.