Forum Discussion
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 factor A with B:1 if i put in A in A:1 or a factor B if i put in B in A:1and return the result in a result cell (C:1 for the argument) .
Have tried with IF function, but always get an error.
I think its a simple formula, but after several tries, i post it here, to maybe get help from the pro's 🙂
Roger
5 Replies
What exactly do you want to multiply with what? Please try to explain more clearly.
- 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.
OliverScheurich That did the trick! thank you for a quick answer.
- rogermon
Just in case you're confused, as I was. 🙂
Note the formula in the picture shows WENN, which is IF in German.
