# Letters represent numbers/ add those numbers to a cell?

#### FLSPEC

##### New Member
Hi. I am trying to set up a spread sheet to help track man power, material cost, budget, actual man hours, and pay.
I have several different pay ranges per different type of "projects" ( if im coating is \$\$ , if im in office its \$\$).

I am trying to set up a number i can play in a column to represent what i was doing, If coatings "C" in the "A3" and have it know that was \$20.00
If i was in the Office have "O" in "A3" and let excel know that 0 = "\$17.50".
Want this to be in a single cell aswell as to be copied in to a column possibly.

When that is done I am trying to get a =SUM of that column i speak of above to add to my man hours column.
looking for B2+c2.

 A B C D 1 Project Type Man Hours Project Cost 2 F350 C 30 (B2+C2) 3 Marketing O 2 (B3+C3) 4 Trainging T 6 (B4+C4)

<tbody>
</tbody>

### Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

#### Tetra201

##### MrExcel MVP
Not sure why you want to sum monetary units and man-hours, but here is the formula:

=CHOOSE(MATCH(B2,{"C","O","T"},0),20,17.5,18.75)+C2

Note: I used 18.75 for code "T" -- replace as needed.

#### FLSPEC

##### New Member
This is just for my record tracking on cost per project. How much it actually cost me per project, and as i have Different pay per Type or work i want to be able to just add a quick Letter to say which area i was working .
then have it add it at the end to see where im at compared to actual. It will help quote jobs later on and help me know where i stand profit wise per job. if that makes sense

do you have a simpler way of doing that?

Thank you for the formula

#### FLSPEC

##### New Member
If i have multiple Rows that needs this how to I use that formula..
sorry its been years since ive messed with this..

#### AliGW

##### Banned
Just drag copy it down.

#### FLSPEC

##### New Member
gives me #VALUE! error

#### Tetra201

##### MrExcel MVP
gives me #VALUE! error
Means you have a non-numeric value in column C.

#### FLSPEC

##### New Member
i tested with B2 "C" b3 "S", C2 "30" C3 "22"
C is just a random number to test.

=CHOOSE(MATCH(B2:B3,{"C","O","T"},0),20,17.5,18.75)*C2:C3

#### Tetra201

##### MrExcel MVP
i tested with B2 "C" b3 "S", C2 "30" C3 "22"
C is just a random number to test.

=CHOOSE(MATCH(B2:B3,{"C","O","T"},0),20,17.5,18.75)*C2:C3
What are you trying to achieve with the above formula?
What is the monetary value for code "S"?
What is the expected result?

#### FLSPEC

##### New Member
 A B C D 1 Project Type Man Hours Project Cost 2 F350 C 30 (B2+C2) 3 Marketing O 2 (B3+C3) 4 Trainging T 6 (B4+C4)

<tbody>
</tbody>

This table represents my simple project tracker..

C = Coatings
O = Office
T = Travel/Training

example. F350 project , I have 30 hours into it right now. But i have 12 in coatings, 10 in Lighting, 8 in body work.
Pay is different for Each type of work being performed. Prevalent wage basically.

Coatings = \$20.00
Lighting = \$17.50
Body work = \$20.00

my objective to acheive here is to set the currency or numeric value for each letter that represents the scope of work. there for when looking at the spreadsheet and i see the C i know that was coating.
aswell as haveing it reprsent the pay scale needed.

Multiply that by the man hours of each scope of work gives me how much that project is costing. that plus cost of materials is cost of the project for me. can now charge accordingly for similar projects.

does that help or make sense?

Replies
10
Views
335
Replies
0
Views
1K
Replies
1
Views
680
Replies
2
Views
97
Replies
19
Views
1K

1,190,827
Messages
5,983,113
Members
439,824
Latest member
nellyc

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back