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.
What I want to do is, in cells B3, C3 and D3 (highlighted in yellow), calculate the overall percentage.
So, cell B3 would be 3/50*100 for example.
But, because there is text in cell B3, as well as a number, I get an error if I try this - how can I fix it?
Thanks.
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
