Forum Discussion
Help required to determine correct calculation methodology/formula
Greetings I am quite a newbie around excel, and I am in the process to design an excel calculator to determine volume in tanks. My question is this: From calibration tables, I observe for examp...
You may use array constants as follows:
=LOOKUP(A7,
{0;1;1.1;1.2},
{0;375;380;417}+({375;50;370;0}*(A7-LOOKUP(A7,{0;1;1.1;1.2}))))
Note the calculation of the following constants:
1. (375-0)/(1-0)=375;
2. (380-375)/(1.1-1)=50; and
3. (417-380)/(1.2-1.1)=370.
=LOOKUP(A7,
{0;1;1.1;1.2},
{0;375;380;417}+({375;50;370;0}*(A7-LOOKUP(A7,{0;1;1.1;1.2}))))
Note the calculation of the following constants:
1. (375-0)/(1-0)=375;
2. (380-375)/(1.1-1)=50; and
3. (417-380)/(1.2-1.1)=370.
Thanks for the prompt reply, I will cross check and revert if any correction need...