Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
which function do i need?
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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
which function do i need?
=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) "Alison" wrote: 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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to combine an IF Function with a lookup function to determine | Excel Worksheet Functions | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |