Re: Identify currency and do sum

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 10/04/04 

Date: Mon, 4 Oct 2004 19:02:46 +0200

Hi Sarah
It is really not a good idea to store text and numbers within one cell.
You'll have to use more complicated formulas. Trust me this creates
more problems with your later processing. also you need a table which
stores the currency conversion factors somethere 

--
Regards
Frank Kabel
Frankfurt, Germany
sg wrote:
> Another question is that how I can pick 100 from 100us using
function.
> Thanks,
> sarah
> "sg" <sarah_guo@yahoo.com> wrote in message
> news:eOHNNEjqEHA.3464@TK2MSFTNGP14.phx.gbl...
>> Hi Frank,
>>
>> thank you for you reply. Since the spread*** is too wide, user
>> doesn't want to split them into one column, that's the problem. And
>> I realized this might be something to do with programming and
>> submitted a thread in programming group as well. Of course if you
>> know the answer, I would appreicate it.
>>
>> Thanks,
>> Sarah
>> "Frank Kabel" <frank.kabel@freenet.de> wrote in message
>> news:uhdT25iqEHA.1644@tk2msftngp13.phx.gbl...
>>> Hi
>>> first try splitting tis information in two columns:
>>> -Column A: amount
>>> - Column B: Currency code (e.g. USD, CAN)
>>>
>>> Now you also have to add the conversion factor (e.g. in column C).
>>> After this use
>>> =SUMPRODUCT(A1:A10,C1:C10)
>>>
>>>
>>> --
>>> Regards
>>> Frank Kabel
>>> Frankfurt, Germany
>>>
>>>
>>> sg wrote:
>>>> Hi everyone,
>>>> I have a spreet*** with one column which requests user to input
>>>> their amount, either can$ or us$, but I want to summary them by
>>>> currency, how would I do this?
>>>> for example:
>>>>
>>>> 100
>>>> us100
>>>> 100
>>>> us100
>>>>
>>>> how can I sum us=200, can=200?
>>>>
>>>> Thanks,
>>>> sarah
Quantcast