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, ...
I guess, it should be...
= 2*(A1+1)*A2*A3And 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 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