SOLVED

A little calculation

Copper Contributor
plz,Look at the picture first. If I know the data for 2000 and 2005. Then how do I get the rest of the information. I calculate using the formula that I gave. But it takes a lot of time. Is there any easy way?
5 Replies
best response confirmed by masumbiklah (Copper Contributor)
Solution

@masumbiklah To calculate the multiplier in Z12, that would be:

=(Y17/Y12)^(1/(X17-X12))

 

Thanks. Riny van eekelen <3. I find exactly this. Now got my answer. Thankyou. <3<3
Friend. If you know plz answer this. If i now cell x12, x15, x17. Y12, y17. & z12. Now i want know Y15. How i can got it?

@masumbiklah Like so, perhaps?

Screenshot 2021-06-21 at 16.24.24.png

Thankyou friend for help me.god bless you. I got my answer. Thankyou.
1 best response

Accepted Solutions
best response confirmed by masumbiklah (Copper Contributor)
Solution

@masumbiklah To calculate the multiplier in Z12, that would be:

=(Y17/Y12)^(1/(X17-X12))

 

View solution in original post