divide one cell by the sum of that cell and another cell

[randraines]

I am trying to divide the value in cell k2 by the sum of k2 and l2. I know i can accomplish this by adding them in m2 then dividing k2 by m2 but i would rather do this in one step. Any ideas?

[TMS]

Please Login or Register  to view this content.

Regards, TMS

[TMS]

or even

Please Login or Register  to view this content.

Regards, TMS

[randraines]

i tried both formulas and i get #VALUE!

[TMS]

Then you have something non-numeric in either K2 and/or L2


Suggest that you post a sample workbook that exhibits the problem

[randraines]

I have uploaded sample of the sheet i am working on. On this the data is now in columns A and B with the formula in C. Thank you for you help.

[TMS]

The numbers in column A all have a trailing non-display character. Use =CODE(RIGHT(A1,1)) to determine what it is.

Either delete that character in each cell or use something like:

Please Login or Register  to view this content.

You could do a global replace using Alt + 0160


Regards, TMS

[randraines]

thank you for your help. i will look into the trailing non-display character.

[TMS]

You're welcome. Thanks for the rep.


If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.