Posted to microsoft.public.excel.worksheet.functions

Matthew

Posts: n/a

valuing a labelled odds formula '15/8 I want result 1.875 ??????

I need one cell to display 15/8 thus using the label.

But I also want to use the result of 15 divided by 8 based on the value from
this cell.

I thought I could use the value and mid functions but it comes out in date
numbers.
The formula needs to apply to a range of odds....eg...100/30, 4/1, 8/13, 6/4
etc...

Please help !

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
Median result used in formula gives incorrect result	vlatham	Excel Worksheet Functions	4	September 21st 05 04:26 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Formula shown as a formula rather than it's result	Tosca	Excel Worksheet Functions	6	May 19th 05 03:39 AM
Amount or Numbers in Words	ron	New Users to Excel	6	December 24th 04 07:32 PM

All times are GMT +1. The time now is 03:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us