Letters represent numbers/ add those numbers to a cell?

FLSPEC

New Member
Joined
Dec 28, 2016
Messages
9
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.


ABCD
1ProjectTypeMan HoursProject Cost
2F350C30(B2+C2)
3MarketingO2(B3+C3)
4TraingingT6(B4+C4)

<tbody>
</tbody>
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
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.
 
Upvote 0
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
 
Upvote 0
If i have multiple Rows that needs this how to I use that formula..
sorry its been years since ive messed with this..
 
Upvote 0
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
 
Upvote 0
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?
 
Upvote 0
ABCD
1ProjectTypeMan HoursProject Cost
2F350C30(B2+C2)
3MarketingO2(B3+C3)
4TraingingT6(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?
 
Upvote 0

Forum statistics

Threads
1,213,491
Messages
6,113,963
Members
448,536
Latest member
CantExcel123

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top