Posted to microsoft.public.excel.misc

Tony S.[_2_] Tony S.[_2_] is offline

external usenet poster

Posts: 60

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dividing zero by zero	Sanjeev Raghavan[_2_]	Excel Worksheet Functions	4	March 1st 10 01:26 PM
Dividing by zero	jvega	Excel Worksheet Functions	13	June 9th 08 10:49 PM
Dividing name	kd	Excel Worksheet Functions	1	April 19th 07 04:48 AM
Dividing by zero	careyc	Excel Discussion (Misc queries)	5	March 17th 06 11:03 PM
dividing a row	LostNFound	Excel Worksheet Functions	2	March 7th 05 05:49 PM

All times are GMT +1. The time now is 01:21 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us