ExcelBanter - Subtracting not Dividing

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Subtracting not Dividing (https://www.excelbanter.com/excel-discussion-misc-queries/234568-subtracting-not-dividing.html)

Tony S.[_2_]

Subtracting not Dividing

I have several cell that each contain (2) numbers separated by "/".
i.e. 1/5, 7/29, 5/187, 42/169 etc.
I want to subtract the numerator form the denominator not divide them. The
results would be:
4, 22, 182, 127

Can someone help with this? Thanks!

--
Tony S.

Jacob Skaria

Subtracting not Dividing

Try the below with the data in cell A1

in B1
=MID(A1,FIND("/",A1)+1,10)-LEFT(A1,FIND("/",A1)-1)

If this post helps click Yes
---------------
Jacob Skaria

"Tony S." wrote:

I have several cell that each contain (2) numbers separated by "/".
i.e. 1/5, 7/29, 5/187, 42/169 etc.
I want to subtract the numerator form the denominator not divide them. The
results would be:
4, 22, 182, 127

Can someone help with this? Thanks!

--
Tony S.

Tony S.[_2_]

Subtracting not Dividing

Excellent.... it works perfectly. Thank you Jacob.
--
Tony S.

"Jacob Skaria" wrote:

Try the below with the data in cell A1

in B1
=MID(A1,FIND("/",A1)+1,10)-LEFT(A1,FIND("/",A1)-1)

If this post helps click Yes
---------------
Jacob Skaria

"Tony S." wrote:

I have several cell that each contain (2) numbers separated by "/".
i.e. 1/5, 7/29, 5/187, 42/169 etc.
I want to subtract the numerator form the denominator not divide them. The
results would be:
4, 22, 182, 127

Can someone help with this? Thanks!

--
Tony S.

All times are GMT +1. The time now is 09:28 PM.