Hello,
In cell A1 i have the number -20
in cell A2 i have the number 5
so the range of the two numbers is 25.
i would like B1 to have a formula that calculates 20% between the two numbers (-20 and 5)
the answer should be -15
thank you
Hello,
In cell A1 i have the number -20
in cell A2 i have the number 5
so the range of the two numbers is 25.
i would like B1 to have a formula that calculates 20% between the two numbers (-20 and 5)
the answer should be -15
thank you
If I follow your logic correctly, then:
Formula:Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Seems like it should be a simple proportionality: (A2-A1)/(1-0)=(x-A1)/(0.2-0) then solve for x.
Originally Posted by shg
ollys worked great. cheers
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks