SOLVED

Find the formula used

%3CLINGO-SUB%20id%3D%22lingo-sub-1706064%22%20slang%3D%22en-US%22%3EFind%20the%20formula%20used%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1706064%22%20slang%3D%22en-US%22%3E%3CH3%20id%3D%22toc-hId-1253503395%22%20id%3D%22toc-hId-1253503428%22%20id%3D%22toc-hId-1253503428%22%20id%3D%22toc-hId-1253503428%22%20id%3D%22toc-hId-1253503428%22%20id%3D%22toc-hId-1253503428%22%3EHow%20do%20I%20find%20out%20what%20was%20the%20formula%20used%20to%20get%20the%20numbers%20in%20the%20D%20column%20using%20all%20or%20a%20few%20of%20the%20numbers%20in%20A%2C%20B%2C%20and%20C%20columns%20in%20Excel%3F%20I%20had%20received%20this%20data%20in%20pdf.%3C%2FH3%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1706064%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1706371%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20the%20formula%20used%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1706371%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F806583%22%20target%3D%22_blank%22%3E%40rockyhimalayas%3C%2FA%3E%26nbsp%3BYou%20can't%20tell%20for%20sure%20unless%20you%20ask%20the%20person%20who%20created%20the%20spreadsheet.%20But%2C%20by%20looking%20at%20the%20numbers%20it%20seems%20that%20column%20C%20%3D%20A%20%2B%20B.%20Column%20D%20%3CSTRONG%3Ecould%20be%3C%2FSTRONG%3E%20(%20A%20*%200.5%20)%20%2B%20(%20B%20*%200.9%20).%20See%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1706686%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20the%20formula%20used%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1706686%22%20slang%3D%22en-US%22%3EThank%20you%20Riny.%20Yes%20you%20are%20right%20about%20both%20column%20C%20and%20D.%20Would%20be%20kind%20to%20help%20understand%20how%20did%20you%20figure%20out%20the%20formula%20used%20for%20column%20D.%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%3CBR%20%2F%3ERakesh%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

How do I find out what was the formula used to get the numbers in the D column using all or a few of the numbers in A, B, and C columns in Excel? I had received this data in pdf.

4 Replies
Highlighted

@rockyhimalayas You can't tell for sure unless you ask the person who created the spreadsheet. But, by looking at the numbers it seems that column C = A + B. Column D could be ( A * 0.5 ) + ( B * 0.9 ). See attached.

Highlighted
Thank you Riny. Yes you are right about both column C and D. Would be kind to help understand how did you figure out the formula used for column D.

Regards
Rakesh
Highlighted
Best Response confirmed by rockyhimalayas (New Contributor)
Solution

@rockyhimalayas By trial and error and some logic. No particular Excel skills needed.

First, I noted that the last two in D were half of A. Then I added B and noticed that the difference with the desired result (where B <> 0), consistently amounted to 10% of B. Hence, adding 0.9 x B did the trick.

If I had not seen the relationship at once, I would have continued with Goal Seek, I guess.

 

Notice though that I said that the formula could be lik that. It is very possible that there are other conditions is the real underlying formula that just don't impact the end result for this five examples given. Better check with the author of the original sheet, if possible.

Highlighted
Thank you so much Riny, for your time and efforts.
Really appreciate.

Best
Rakesh