Mar 26 2021 08:34 AM
=(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.
Mar 26 2021 08:40 AM
@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.
Mar 26 2021 08:49 AM
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.
Mar 26 2021 08:55 AM
@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.
Mar 26 2021 09:32 AM
@lizalexandersurgical Well, can you tell which cells has what value and how you want to multiply and sum them?
Mar 26 2021 09:40 AM
Mar 26 2021 09:49 AM
@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.
Mar 26 2021 09:55 AM
Mar 26 2021 10:05 AM - edited Mar 26 2021 10:13 AM
Mar 26 2021 10:05 AM - edited Mar 26 2021 10:13 AM
Solution@lizalexandersurgical Then that would be:
=D1614*$H$2+F1614*$I$2+G1614*$J$2*I1614
equaling 852.90 (rounded).
Mar 26 2021 10:05 AM - edited Mar 26 2021 10:13 AM
Mar 26 2021 10:05 AM - edited Mar 26 2021 10:13 AM
Solution@lizalexandersurgical Then that would be:
=D1614*$H$2+F1614*$I$2+G1614*$J$2*I1614
equaling 852.90 (rounded).