# Excel Formula

Occasional Contributor

# Excel Formula

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 Feb March Total A 3 5 6 14 0.311111 B 20 10 15 45 0.15 0.5 0.4
7 Replies

# Re: Excel Formula

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

# Re: Excel Formula

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

# Re: Excel Formula

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.

# Re: Excel Formula

I can only use 0.15, 0.5 and 0.4 to get 0.31111

# Re: Excel Formula

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 !!!