Forum Discussion
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. ...
Below formula will do the work:
=(LEFT(C2;FIND("(";C2;1)-1)*1)/A2*100
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!=(LEFT(C2;FIND("(";C2;1)-1)*1)/(LEFT(A2;FIND("(";A2;1)-1)*1)*100
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!
