Help with math equations and cell linking

[Pharmacisticus]

Hi All,

I've got a strange question here...

I have a cell A1 that has the numbers '5/100' in it.
I want cell A2 to calculate that to 5%

I can't seem to make it work!

Help

Kind regards,

Pharmacisticus

 

[Rick Rothstein]

Give this formula a try and format the cell you put it in as Percentage...

=LEFT(A1,FIND("/",A1)-1)/MID(A1,FIND("/",A1)+1,3)

 

[KolGuyXcel]

Just adding to Rick's formula, considering that there might be a number more than 999 AFTER the "/", we could try this!

=LEFT(A1,FIND("/",A1)-1)/MID(A1,FIND("/",A1)+1,LEN(A1)-FIND("/",A1))

 

[Rick Rothstein]

Just adding to Rick's formula, considering that there might be a number more than 999 AFTER the "/", we could try this!

=LEFT(A1,FIND("/",A1)-1)/MID(A1,FIND("/",A1)+1,LEN(A1)-FIND("/",A1))

Good point. I was seduced by the 100 and request for a percentage into thinking the denominator would be a number from 1 to 100, but you are correct, the question does not limit the denominator that way. However, there is no need to complicate the formula like that... The MID function does not care if you ask it for more characters in the third argument than there actually are... it will simply use what is there. Given that, this formula should cover whatever the OP might send its way...

=LEFT(A1,FIND("/",A1)-1)/MID(A1,FIND("/",A1)+1,99)