I’m trying to get a cost per service result by stringing together a complicated math formula.
The math equation I’m trying to use, which I need a way to calculate correctly in Excel is, (1 x 2) + (3 x 4) + (1/5 x 6) / 8
See attached spreadsheet. Where you see a number in the equation above, that number correlates to the value in the second cell under column B.
As you can see, if I just string it altogether in Excel as one formula, it gives me a result of 32,966.29.
But I also broke out the equation into separate strings to get the result I should be getting – 2.69
How can I get Excel to calculate that entire equation together so that it gives me the 2.69 without having to break it down in separate cells?
Bookmarks