which function do i need?

A

Alison

Hi I have tried but this is friving me crazy. I am trying to keep track of
the shifts i work and the pay per shift. Each shift has a different rate. In
the colums i have date, shift, pay, hours and gross pay. The first doesnt
need a formula and the last 2 i have worked out. The problem is making it so
that everytime I have eg a Morning shift, not having to type in morning. I
was hoping to just type in a number and excel looked up what that number and
replaced it with whichever shift it corresponded to. The second possibly more
complicated one is a formula that could look at what was typed in column
named "shift" and in the same row in the colum "pay" put the pay rate eg
Morning = 25.5119 Afternoon = 28.7009 If that isnt able to be done i can just
use the first formula changed around a bit. Hope someone can help me!!!
 
T

tim m

=IF(B2="Morning",25.5119,IF(B2="Afternoon",28.7009,"Error"))

you could try putting the above formula in your pay column. If you type
Morning in your shift column it puts the morning pay rate, if you type
Afternoon in the shift it gives the afternoon pay rate, if you mistype and
make a mistake it will show up as error. If you want to make it even simpler
you could just type M for morning and A for afternoon and just make a note
somehwere on the sheet that M stands for morning and A for afternoon. (You
would of course have to make that change in the formula as well.)

(You will want to copy the formula down of course and I started the formula
in B2 because i assume headings are in row A)
 
Top