| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A1 = 200:1, B1 is 200 / 1 (200 from A1 - How to exclude :1?)
I need to figure out how to convert 200:1 in cell A1 to 200 for cell B1,
which would then be divided by 1 A1 B1 200:1 I need to exclude the :1 from 200:1 and then divide 1 by 200 for cell B, so the result would be .05 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
A1 = 200:1, B1 is 200 / 1 (200 from A1 - How to exclude :1?)
I get .005 not .05, but
=1/(LEFT(A1,FIND(":",A1)-1)) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "wcooke" wrote in message ... I need to figure out how to convert 200:1 in cell A1 to 200 for cell B1, which would then be divided by 1 A1 B1 200:1 I need to exclude the :1 from 200:1 and then divide 1 by 200 for cell B, so the result would be .05 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I exclude E11 from: =FREQUENCY(E$4:E$24,$B$27:$B$32) | Excel Discussion (Misc queries) | |||
| Exclude a row from a SUM | Excel Discussion (Misc queries) | |||
| Exclude all but last text to the right | Excel Worksheet Functions | |||
| Exclude | Excel Discussion (Misc queries) | |||
| How to exclude data already used? | New Users to Excel | |||
Hybrid Mode
