
Originally Posted by
MrShorty
I agree that the explanation, if present, is at best incomplete.
I see a formula for Ca (Ca being the arithmetic version, the values in row 4) -- Ca=B-x*(B-A) where x is the values in C2:F2.
I see a formula for Cl (Cl being the logarithmec version, the errors in row 8) -- log(Cl)=log(B)-y*(log(B/A)) where y would be the values in C6:F6.
My guess is that you want to find the values for y that make Ca=Cl. If so, I find that I would prefer to solve this first as an algebra problem, then I will be better able to program the appropriate formulas in the spreadsheet.
Am I guessing right at what you are trying to do?
Bookmarks