Oct 17 2022 04:52 AM
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
Oct 17 2022 05:04 AM
SolutionOct 17 2022 05:06 AM
What exactly do you want to multiply with what? Please try to explain more clearly.
Oct 17 2022 04:14 PM
Oct 17 2022 11:37 PM
@OliverScheurich That did the trick! thank you for a quick answer.
Oct 17 2022 11:39 PM
Oct 17 2022 05:04 AM
Solution=IF(A1="A",B1*3,IF(A1="B",B1*4,""))
Maybe with a nested IF formula.