SOLVED

Calculate across cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2237953%22%20slang%3D%22en-US%22%3ECalculate%20across%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2237953%22%20slang%3D%22en-US%22%3E%3CP%3E%3D(D1614*%24H%242)%2B(F1614*%24I%242)%2B(G1614*%24J%242)*I1614.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20not%20coming%20up%20with%20the%20correct%20value.%20what%20is%20wrong%20with%20the%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2237953%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2237963%22%20slang%3D%22en-US%22%3ERe%3A%20Calculate%20across%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2237963%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1009704%22%20target%3D%22_blank%22%3E%40lizalexandersurgical%3C%2FA%3E%26nbsp%3BThat%20depends!%20What's%20in%20all%20these%20cells%20and%20what%20is%20the%20result%20you%20expect%20to%20see%3F%3C%2FP%3E%3CP%3EPerhaps%20you%20need%20some%20extra%20brackets%20in%20the%20correct%20place.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

=(D1614*$H$2)+(F1614*$I$2)+(G1614*$J$2)*I1614.

 

I am not coming up with the correct value. what is wrong with the formula.

9 Replies

@lizalexandersurgical That depends! What's in all these cells and what is the result you expect to see?

Perhaps you need some extra brackets in the correct place.

@Riny_van_Eekelen 

lizalexandersurgical_0-1616773460734.png

I am multiply the two matched colored cells and add them each together.  Then multiply the total by the conversion cell.  My formula should give me the "expected reimb", but its off.  The actual is the amount at the top that I did separately $3288.92, not 852.90. 

@lizalexandersurgical From your description I suspect you can adjust the formula to :

=(D1614*$H$2+F1614*$I$2+G1614*$J$2)*I1614.

 This will sum three multiplications and then multiply that sum with the value in I1614.

That formula doubled the answer.

@lizalexandersurgical Well, can you tell which cells has what value and how you want to multiply and sum them?

It should have worked, we are multiplying two cells and adding the next set of multiplied cells.
D1614*H2 add to
F1614*I2 add to
G1614*J2 then multiplying the result by the last cell I1614

@lizalexandersurgical My formula should work then. For example, (2 x 3 + 2 x 3 + 2 x 3) x 10 = 180 (i.e. 6+6+6 = 18 x 10 = 180). If you don't give me your numbers, I can't help you any further.

I am sorry, I misunderstood...
57.01 x 1.000 + 41.91 x 0.916 + 11.36 x 1.195 x 55.80 =
best response confirmed by lizalexandersurgical (Occasional Contributor)
Solution

@lizalexandersurgical Then that would be:

 

=D1614*$H$2+F1614*$I$2+G1614*$J$2*I1614

 

equaling 852.90 (rounded).