Forum Discussion
Solved
Help with Excel formula
Hi, I am pulling my hair out trying to write an Excel formula for the following action - can you help. Essentially, depending on the value entered into A1, the value in A2 should be multiplied by 4, ...
SergeiBaklan Thanks, but I don't think this formula will do what I need. Users can only enter 1, 2, 3 or 4 into A1, so the formula I'm trying to create needs to say:
If 1 is entered into A1, do (A2 * 4) *3
If 2 is entered into A1, do (A2 * 6) *3
If 3 is entered into A1, do (A2 * 😎 *3
If 4 is entered into A1, do (A2 * 10) *3
First variant of requirements is
If A1 = 1, then MULTIPLY A2 by 4 and MULTIPLY the result by A3
BUT
If A1 = 2, then MULTIPLY A2 by 6 and MULTIPLY the result by A3
BUT
If A1 = 3, then MULTIPLY A2 by 8 and MULTIPLY the result by A3
BUT
If A1 = 4, then MULTIPLY A2 by 10 and MULTIPLY the result by A3Latest one
If 1 is entered into A1, do (A2 * 4) *3
If 2 is entered into A1, do (A2 * 6) *3
If 3 is entered into A1, do (A2 * *3
If 4 is entered into A1, do (A2 * 10) *3Which one is correct?
SergeiBaklan In the second version, I should have written *A3 (not *3). With that amend, the two requirements are the same - I tried to simplify them in the second version. Thanks,
When the formula as before shall work
SergeiBaklan I see how it works now. Thanks for taking the time to solve this for me.