Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Assigning number values to text strings
Does anyone know whether it's possible in Excel to create a formula
that assigns a particular number value to a particular text string if found? I'm trying to create a merge document in Word using an Excel datasheet. The merged letters are bills for clients that should be billed different based on level. So, for example: Let's say these are the levels: Level 1= $45, Level 2= $295. There are also some other fields that are simpler to add because they are all already in number format. But if I want to calculate the total for Client 1 who is at Level 2, what formula would I create in order to return a dollar value if the information that indicates which level the client is at says "Level 2" rather than $295? Thanks! Nick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct issues | Excel Worksheet Functions | |||
Average only first number of actual values | Excel Worksheet Functions | |||
Convert text strings to a code or number | Excel Worksheet Functions | |||
How do I look up a number within a string of text | Excel Worksheet Functions | |||
VB Assigning Values to a Series of Strings | Excel Discussion (Misc queries) |