Forum Discussion

Iron Contributor

Dec 13, 2018

How to calculate percentage of two numbers when one cell contains non-numbers?

Hi Everyone. I have a spreadsheet that looks like this: As you can see, cells B2, C2 and D2 is where I manually type the values and include a difference in brackets from the previous week. ...

excel

Formulas and Functions

erol sinan zorlu

Iron Contributor

Dec 13, 2018

Below formula will do the work:

=(LEFT(C2;FIND("(";C2;1)-1)*1)/A2*100

ianwuk

Iron Contributor

Dec 13, 2018

Thanks for replying erol sinan zorlu

Here is more about what I am working with.

As you can see, there is also text in cell A2 that forms the basis of the overall calculation.

How can you formula above be adapted to work with the above data?

Many thanks!

erol sinan zorlu
Iron Contributor
Dec 13, 2018
=(LEFT(C2;FIND("(";C2;1)-1)*1)/(LEFT(A2;FIND("(";A2;1)-1)*1)*100
- ianwuk
  Iron Contributor
  Dec 13, 2018
  Hi erol sinan zorlu, sorry for me being such an idiot but do I put that formula in cell B3? I am a little confused. When I do try to put the formula in, Excel doesn't seem to accept it.
  
  Is there any chance you can put your formula in the highlighted cells of the attached sheet please? It may be easier.
  
  Thanks so much!
  Test.xlsx10 KB
  - erol sinan zorlu
    Iron Contributor
    Dec 13, 2018
    please read the article given in below link.
    
    https://support.office.com/en-us/article/switch-between-relative-absolute-and-mixed-references-dfec08cd-ae65-4f56-839e-5f0d8d0baca9