Excel Formula

%3CLINGO-SUB%20id%3D%22lingo-sub-2243599%22%20slang%3D%22en-US%22%3EExcel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2243599%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20calculation%20wherein%200.31111is%20the%20cumulative%20of%20A%2FB.%20Assuming%20that%20I%20have%20only%20access%20to%20data%20in%20the%20row%20below%20B%20and%20I%20do%20not%20have%20access%20to%20data%20in%20row%20A%20and%20B%2C%2C%20how%20do%20I%20develop%20the%20Excel%20function%20to%20arrive%20to%200.31111.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22384%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EJan%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EFeb%3C%2FTD%3E%3CTD%20width%3D%2264%22%3EMarch%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2264%22%3ETotal%3C%2FTD%3E%3CTD%20width%3D%2264%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EA%3C%2FTD%3E%3CTD%3E3%3C%2FTD%3E%3CTD%3E5%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E14%3C%2FTD%3E%3CTD%3E0.311111%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EB%3C%2FTD%3E%3CTD%3E20%3C%2FTD%3E%3CTD%3E10%3C%2FTD%3E%3CTD%3E15%3C%2FTD%3E%3CTD%3E45%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E0.15%3C%2FTD%3E%3CTD%3E0.5%3C%2FTD%3E%3CTD%3E0.4%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2243599%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-2243688%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2243688%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928871%22%20target%3D%22_blank%22%3E%40Chan_Tze_Leong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20is%20not%20possible%20unless%20the%20values%20in%20B3%3AD3%20are%20identical.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2243873%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2243873%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F928871%22%20target%3D%22_blank%22%3E%40Chan_Tze_Leong%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20simple%20just%20drag%20the%20formula%20in%20cell%20B4%20till%20E4%2C%20and%20you%20get%20the%20expected%20value%200.311111%2C%20check%20the%20attached%20sheet!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi 

I have calculation wherein 0.31111is the cumulative of A/B. Assuming that I have only access to data in the row below B and I do not have access to data in row A and B,, how do I develop the Excel function to arrive to 0.31111.

 

 Jan FebMarch Total 
A356140.311111
B20101545 
 0.150.50.4  
      
7 Replies

@Chan_Tze_Leong 

That is not possible unless the values in B3:D3 are identical.

 

@Chan_Tze_Leong 

It's simple just drag the formula in cell B4 till E4, and you get the expected value 0.311111, check the attached sheet!!

Hi Rajesh, Your solution of dragging B4 to E4 means it copies the formula of E4=E2/E3. I mentioned earlier that I cannot use Rows A and B which are rows 2 and 3.
I can only use 0.15, 0.5 and 0.4 to get 0.31111
Unless you will not use the values from B2:E4 the how would you expect the magical value 0.311111!! Even builtin command Goal seek need the value to adjust, if you use value from Row 4,, B4 to E4,,, remember values headed by A & B in Range B2:E4 are the source value,,,, and ultimately the EXCEL needs vakue to be manipulated / calculated !!!
I merely asked whether it is possible. Please take your anger issues elsewhere.
It's like ignoring the basics of data handling using the Excel,,,, and my sincere efforts are to elaborate that how to achieve,,, and nothing,, !!