Forum Discussion

ianwuk's avatar
ianwuk
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's avatar
erol sinan zorlu
Iron Contributor
Dec 13, 2018

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

ianwuk's avatar
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!

  • erol sinan zorlu's avatar
    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

    • ianwuk's avatar
      ianwuk
      Iron Contributor
      Dec 13, 2018

      Thanks erol sinan zorlu.  I will take a look.

Resources