this may be more of a math question but in column A i have a rolling 12 month balance column B is a basis points assigned to a product Column C is the "new value"
example below...my question is if a user only got the new value (column c) how could they back into column A (assuming they knew the basis points)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A Rolling 12 month Avg[/TD]
[TD]Column B BPS[/TD]
[TD]Column C New Value[/TD]
[/TR]
[TR]
[TD]$16,306[/TD]
[TD].0045[/TD]
[TD]$73.37[/TD]
[/TR]
</tbody>[/TABLE]
example below...my question is if a user only got the new value (column c) how could they back into column A (assuming they knew the basis points)
[TABLE="width: 500"]
<tbody>[TR]
[TD]Column A Rolling 12 month Avg[/TD]
[TD]Column B BPS[/TD]
[TD]Column C New Value[/TD]
[/TR]
[TR]
[TD]$16,306[/TD]
[TD].0045[/TD]
[TD]$73.37[/TD]
[/TR]
</tbody>[/TABLE]