On 18/10/2007, Harold Fuchs <[EMAIL PROTECTED]> wrote:
>
>
>
> On 17/10/2007, Richard J Neuenfeldt <[EMAIL PROTECTED]> wrote:
> >
> > In column G, I have three possible combinations, 1/25#,. 6/5#, 10/5# or
> > 4/12.5#. If one multiplies "4 times 12.5#" , one gets "50#". Thanks
> > again, Richard
> >
> >
> I really don't mean to be rude but this is nonsense. Apart from saying
> "three possible combinations" and then listing four, the combinations do
> *not* represent numbers according to any sensible pattern.
>
> Does "1/25#" mean 25? If not, what?
> Does "10/5#" mean 5? If not, what?
>
> Are you saying that anything between the "/" and the "#" is to be
> multiplied by 4?
>
> Please *define* i.e. specify the rule for identifying the piece of the
> text in column G that is to be interpreted as a number and then multiplied
> by 4.
If my definition is correct - the value to be worked on lies between the "/"
and the "#" then,
in column H put =RIGHT(G1;LEN(G1)-FIND("/";G1))
and in column I put =4*LEFT(H1;LEN(H1)-1)
Column H gets everything to the right of the "/". Column I gets 4 times the
value of everything in column H to the left of the "#".
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
