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...