Re: Identify currency and do sum

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 spreadsheet 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 spreetsheet 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

Relevant Pages

  • Re: How to overcome very slight calculation error.
    ... Dim MyNumber As Single ... you can't store, or nor use "real" numbers, as they are a approximates. ... solution in this case is to use decimal number, or a data type of currency. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Worsheet consolidation
    ... You have been a tremdous help ... I modified the formula to obtain the the store number from column A and have the data read lengthwise ... > Frank Kabel ... > Frankfurt, Germany ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Need way to see which combinations of which fields equal given number
    ... first the problem is where to store the results. ... A brute force algorithmn would simply loop trough the array, ... one combination an check if this is equal to the desired sum. ... > "Frank Kabel" schreef in bericht ...
    (microsoft.public.excel.misc)
  • Re: Accounts/Bookkeeping data type
    ... I'm never going to want to store currency amounts to more than 2 DP - it ... > It is best to define the amount fields in the tables as Data Type: ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Stealing a laptop Advice needed
    ... kind of alarm system attached to it's USB slot. ... To disable the security, the easiest way would to be to go into the store ... with some kind of currency. ...
    (alt.2600)