On 19/10/2007, Harold Fuchs <[EMAIL PROTECTED]> wrote:
>
>
>
> On 18/10/2007, Richard J Neuenfeldt < [EMAIL PROTECTED]> wrote:
> >
> > I am sorry that I listed four combinations which is correct. But what
> > I meant in regards to equal is the first number times the second number
> > that came after the slash "/". In other words 10 times 5 #s. What is
> > occurring is that wheat and corn are forcing me to raise prices five
> > cents a pound. My package prices are not the same originally for the
> > different combinations to begin with. Thanks very much for responding
> > to my problem; it seems that I put an impossible problem to solve and I
> > thank you all for your time and effort. Richard
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> Given these examples: "1/25#,. 6/5#, 10/5# and 4/12.5#" is what you want
> 1*25, 6*5, 10*5 and 4*12.5?
>
> If so, then what I have shown you up to now, using the LEFT, FIND and
> RIGHT functions are sufficient for you to do what you want.
>
> In any case, LEFT, RIGHT and FIND are entirely sufficient for you to split
> your column into two numbers: the first consisting of the characters to the
> left of the "/" and the second consisting of the characters between the "/"
> and the "#". Having split the column into two *separate* columns, you can
> then do what you like with the results.
>
> I suggest you read the Help about these functions.
>
> I further suggest that you take the other advice you have been receiving
> in this correspondence and, in future, *plan* the construction of your
> spreadsheets in such a way as to avoid such entirely unnecessary
> complications.
>
>
>
> --
> Harold Fuchs
> London, England
> Please reply *only* to [email protected]
The easiest way is to split the data into two *numbers* and put each into a
separate *column*. Then make a third column which is the product of these
two. ("product" = result of a multiplication).
In column H put the position of the "/": =FIND("/";G1)
In column I put the position of the "#": =FIND("#";G1)
In column J put the value of the number represented by the characters to the
left of the "/": =VALUE(LEFT(G1;H1-1))
In column K put the value of the number represented by the characters
between the "/" and the "#": =VALUE(MID(G1;H1+1;I1-H1-1))
In column L put the product (the mathematical term for the result of a
multiplication sum) of the numbers in columns K & L: =J1*K1
Done.
Now *please* redesign your spread sheet, and *all* your future spreadsheets
so that you don't *ever* have to perform these crazy contortions again.
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
