Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I have a sheet with a table which has number of hours in a column A. Salary per hour is in column B as under. 50 3.5 100 5.7 150 7.7 300 8.8 This is not just simple multiplication function. If you notice, first 3 rows in A total up to 300 hours and 4th row has 300. It means that if someone has worked for say 425 hours, I need to pay for first 50 hours 3.5 per hour, next 100 hours 5.7 per hour, next 150 , 7.7 hour and rest ( above 300 ) 125 hours, 8.8 per hour.. I have a cell that displays hours. How do i get values from this table? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run-time error '50290': Application-defined or object-defined erro | Excel Discussion (Misc queries) | |||
Pivot tables missing fields from defined table | Excel Discussion (Misc queries) | |||
Application-defined or object-defined error Please Help | Excel Discussion (Misc queries) | |||
Pivot Table - report product that have sales above defined level | Excel Discussion (Misc queries) | |||
"User-defined type not defined" message in Excel | Excel Discussion (Misc queries) |