Dear Team,

Kindly assist me in changing value of a cell to a fixed number by changing various cell.
In goal seek we can do this by setting one cell only.

Actually, I am working on macro enabled sheet which is locked and preset formulas. I have to fill values in only one column which will multiply with other fixed cell column. All numbers are by default set to 2 decimal point. Finally sum is added with fixed percentage and is summed up with nearest 2 decimal.

I want sum to be of specific value. But by changing any one value it is either changed by +.01 or by -.01

Kindly assist.