Forum Discussion
Help with multiplication of several cells
I am a union representative and negotiate labor agreements. I am wanting to calculate "new money." In other words, I want to see how much the wage increase per year will be realized in a member's paycheck.
I believe you are right. I will make a new column to get this done, instead of trying to make a difficult formula. Also, it will be easier for a person to understand when looking at it because the work will be shown.
Terry
You wrote: I will make a new column to get this done, instead of trying to make a difficult formula. Also, it will be easier for a person to understand when looking at it because the work will be shown.
Exactly. And if you use "named ranges" for your calculations, it makes it easier still to see what the formula is doing. You could create a table off to the side ... and use the labels to name the ranges (look it up in Excel Help)
Then your formulas are entirely intelligible, AND you can do "what-if" by changing the assumptions and seeing the results without changing the formulas. See the attached. Here's an image, but the attached Excel file is "live".