I need a formula for J8 based on the information from J1:J7 that would be based on the information from A1:F7
J1= dropdown menu of currency
J2= Manual number someone inputs
J3:J7= dropdown menu of Y or N
If J3= Yes, than J3=J2 (example, if J2= 3 and J3= Y than the total would be 6 because 3+3=6)
If J4= Yes, than J4=J2 (example, if J2= 3 and J4= Y than the total would be 6 because 3+3=6)
Example 1:
J1= USD
J2= 3
J3 = Y
J4= N
J5= N
J6= N
J7= N
Then J8= 1,044 because J2= 3*300 and J3= 3*48
Example 2:
J1= USD
J2= 5
J3 = N
J4= Y
J5= N
J6= Y
J7= N
Then J8=5,980 because J2= 5*300, J4=96*5, and J6=4000
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Packages[/TD]
[TD="align: center"]USD[/TD]
[TD="align: center"]AUD[/TD]
[TD="align: center"]CAD[/TD]
[TD="align: center"]EUR[/TD]
[TD="align: center"]GBP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Currency[/TD]
[TD="align: center"]USD[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Users[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]288[/TD]
[TD="align: center"]240[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Number of Users
[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]96[/TD]
[TD="align: center"]96[/TD]
[TD="align: center"]96[/TD]
[TD="align: center"]96[/TD]
[TD="align: center"]84[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]2000[/TD]
[TD="align: center"]2200[/TD]
[TD="align: center"]2200[/TD]
[TD="align: center"]1900[/TD]
[TD="align: center"]1600[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]4000[/TD]
[TD="align: center"]4400[/TD]
[TD="align: center"]4400[/TD]
[TD="align: center"]3800[/TD]
[TD="align: center"]3200[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]8800[/TD]
[TD="align: center"]8800[/TD]
[TD="align: center"]8800[/TD]
[TD="align: center"]8400[/TD]
[TD="align: center"]7050
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]11
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Please let me know if this is at all possible.
Thank you in advance if anyone can figure out this complicated formula!
J1= dropdown menu of currency
J2= Manual number someone inputs
J3:J7= dropdown menu of Y or N
If J3= Yes, than J3=J2 (example, if J2= 3 and J3= Y than the total would be 6 because 3+3=6)
If J4= Yes, than J4=J2 (example, if J2= 3 and J4= Y than the total would be 6 because 3+3=6)
Example 1:
J1= USD
J2= 3
J3 = Y
J4= N
J5= N
J6= N
J7= N
Then J8= 1,044 because J2= 3*300 and J3= 3*48
Example 2:
J1= USD
J2= 5
J3 = N
J4= Y
J5= N
J6= Y
J7= N
Then J8=5,980 because J2= 5*300, J4=96*5, and J6=4000
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[TD="align: center"]K[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Packages[/TD]
[TD="align: center"]USD[/TD]
[TD="align: center"]AUD[/TD]
[TD="align: center"]CAD[/TD]
[TD="align: center"]EUR[/TD]
[TD="align: center"]GBP[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Currency[/TD]
[TD="align: center"]USD[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Users[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]300[/TD]
[TD="align: center"]288[/TD]
[TD="align: center"]240[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Number of Users
[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]48[/TD]
[TD="align: center"]36[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]A[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]96[/TD]
[TD="align: center"]96[/TD]
[TD="align: center"]96[/TD]
[TD="align: center"]96[/TD]
[TD="align: center"]84[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]2000[/TD]
[TD="align: center"]2200[/TD]
[TD="align: center"]2200[/TD]
[TD="align: center"]1900[/TD]
[TD="align: center"]1600[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]4000[/TD]
[TD="align: center"]4400[/TD]
[TD="align: center"]4400[/TD]
[TD="align: center"]3800[/TD]
[TD="align: center"]3200[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]D[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]8800[/TD]
[TD="align: center"]8800[/TD]
[TD="align: center"]8800[/TD]
[TD="align: center"]8400[/TD]
[TD="align: center"]7050
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]N[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]Total[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]11
[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Please let me know if this is at all possible.
Thank you in advance if anyone can figure out this complicated formula!