How to enter codes in excel and have corresponding payment sum ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to learn how to make an excel spreadsheet that I could enter
codes and have the corresponding payouts sum up. I work as an installer for a
cable company and each job I do consists of codes for work done ( i.e. code
250 -Ran 1 outlet= $8.25, code 251- ran 2 outlets= 16.5 etc..). I would like
to be able to enter these codes at the end of the day and see how much I made
that day. Is this possible? I know very little about Excel, but do have alot
of computer savy. Please help :)
 
The starting point would be for you to build up a table of codes,
description and price, something like this:

250 Ran 1 outlet 8.25
251 Ran 2 outlets 16.50
etc

You could put this in a sheet of its own, so that it doesn't get in the
way of the other calculations - let's assume that you rename the sheet
to "Codes" and the completed table occupies A1 to C50.

In another sheet you could enter your codes into column A and the
appropriate description and cost could be brought automatically from
the other sheet. So, assume that you will start putting data in to A1,
then enter these formulae in to B1 and C1:

B1: =IF(A1="","",VLOOKUP(A1,Codes!A$1:C$50,2,0))
C1: =IF(A1="","",VLOOKUP(A1,Codes!A$1:C$50,3,0))

You could format cell C1 as currency with 2 dp, then copy the formulae
in B1:C1 downwards for as many codes as you expect to be entering in a
day.

Just type a code into A1, and the description and price will appear
next to it. If the code doesn't exist in your table, then you will have
#N/A returned.

Hope this helps.

Pete
 
Back
Top