Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give text a dollar numeric value
How do I give text codes eg. "LC" or "MC" a numeric or dollars value? I want
the numeric value to be hidden so I am able to insert text codes into cells then sum a total at the end of a column and/or the bottom of a row that displays a numeric total. I will have not more than ten text codes for each column. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give text a dollar numeric value
=SUM(INDEX(N1:N10,IF(ISNUMBER(MATCH(C1:C2,M1:M10,0 )),MATCH(C1:C2,M1:M10,0))))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gav" wrote in message ... How do I give text codes eg. "LC" or "MC" a numeric or dollars value? I want the numeric value to be hidden so I am able to insert text codes into cells then sum a total at the end of a column and/or the bottom of a row that displays a numeric total. I will have not more than ten text codes for each column. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give text a dollar numeric value
This assumed that the codes and values are in M1:N10, and C1:C2 are the
coded values to sum. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gav" wrote in message ... How do I give text codes eg. "LC" or "MC" a numeric or dollars value? I want the numeric value to be hidden so I am able to insert text codes into cells then sum a total at the end of a column and/or the bottom of a row that displays a numeric total. I will have not more than ten text codes for each column. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give text a dollar numeric value
Insert/ Name/ Define/ put in your name/ refers to/ put in your number.
-- David Biddulph "Gav" wrote in message ... How do I give text codes eg. "LC" or "MC" a numeric or dollars value? I want the numeric value to be hidden so I am able to insert text codes into cells then sum a total at the end of a column and/or the bottom of a row that displays a numeric total. I will have not more than ten text codes for each column. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give text a dollar numeric value
"Bob Phillips" wrote: This assumed that the codes and values are in M1:N10, and C1:C2 are the coded values to sum. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gav" wrote in message ... How do I give text codes eg. "LC" or "MC" a numeric or dollars value? I want the numeric value to be hidden so I am able to insert text codes into cells then sum a total at the end of a column and/or the bottom of a row that displays a numeric total. I will have not more than ten text codes for each column. This almost did what I wanted. I,ll try to be more specific.Column A will be for a particular service say mow lawn. The codes for column may be S for small lawn, M for medium and L for large. Column B will be the same except for a different service but the same principle with the codes, although different codes. At the bottom of A eg. A50 I want to sum the codes numeric values eg. A=5, B=10 etc, two A's and four B's would =50. Then across each row (a row for each client) Sum the codes as per the column set up. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give text a dollar numeric value
"David Biddulph" wrote: Insert/ Name/ Define/ put in your name/ refers to/ put in your number. -- David Biddulph "Gav" wrote in message ... How do I give text codes eg. "LC" or "MC" a numeric or dollars value? I want the numeric value to be hidden so I am able to insert text codes into cells then sum a total at the end of a column and/or the bottom of a row that displays a numeric total. I will have not more than ten text codes for each column. This did not seem to work at all any other suggestions/ |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
give text a dollar numeric value
Can you layout an example, I don't understand?
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gav" wrote in message ... "Bob Phillips" wrote: This assumed that the codes and values are in M1:N10, and C1:C2 are the coded values to sum. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Gav" wrote in message ... How do I give text codes eg. "LC" or "MC" a numeric or dollars value? I want the numeric value to be hidden so I am able to insert text codes into cells then sum a total at the end of a column and/or the bottom of a row that displays a numeric total. I will have not more than ten text codes for each column. This almost did what I wanted. I,ll try to be more specific.Column A will be for a particular service say mow lawn. The codes for column may be S for small lawn, M for medium and L for large. Column B will be the same except for a different service but the same principle with the codes, although different codes. At the bottom of A eg. A50 I want to sum the codes numeric values eg. A=5, B=10 etc, two A's and four B's would =50. Then across each row (a row for each client) Sum the codes as per the column set up. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to give text of value($1.01 = "one dollar and one cents") | Excel Worksheet Functions | |||
Numeric in Text to convert back to the form of Numeric for VLookup Purposes | Excel Discussion (Misc queries) | |||
convert $1.00 to text one dollar. | Excel Worksheet Functions | |||
convert $1.00 to text one dollar. | Excel Worksheet Functions | |||
Dollar text | Excel Discussion (Misc queries) |