ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Assigning number values to text strings (https://www.excelbanter.com/excel-discussion-misc-queries/122003-assigning-number-values-text-strings.html)

[email protected]

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



All times are GMT +1. The time now is 06:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com