Forum Discussion

LeDanJohnson's avatar
LeDanJohnson
Copper Contributor
Sep 17, 2019
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, ...
excel
Formulas and Functions
Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Sep 18, 2019

LeDanJohnson 

I guess, it should be...

= 2*(A1+1)*A2*A3

And what if A1=0?

If you don't want to calculate when A2=0 or blank, then it should be...

=IF(A1=0,"", 2*(A1+1)*A2*A3)

And what if A1>4, would you like to calculate by following the pattern or you would not like to calculate then?

If you don't want to calculate if either A1=0 or A1>4 then...

=IF(OR(A1=0,A1>4),"", 2*(A1+1)*A2*A3)
    • Subodh_Tiwari_sktneer's avatar
      Subodh_Tiwari_sktneer
      Silver Contributor
      Sep 18, 2019

      LeDanJohnson 

      You're welcome! Glad we could help.

      Now you may mark your question as Solved by choosing one of the posts which resolved your question as Best Answer/Response.

      You may also click on Like buttons under the posts which you found helpful, that's another way to say thanks.

  • LeDanJohnson's avatar
    LeDanJohnson
    Copper Contributor
    Sep 18, 2019

    Subodh_Tiwari_sktneer Thanks, but I don't think that quite covers what I need. Users are limited to the number they can enter into A1 - it's either 1, 2, 3 or 4. The difficulty I'm having is in writing a formula that says:

    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

Resources