Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with a worksheet
A co-worker has been working really hard on this and has previously posted,
but shes stumped. Here's our situation - We need a spreadsheet for tracking bonuses. There will be 7 columns - date, policyholder, policy, type, premium, bonus and initials. We'll fill in the date, policyholder and initials columns. We created dropdown boxes for the policy and type columns. Once we choose the Policy, we need the Type dropdown list to be a dependent dropdown, (with only the associated "Types" showing), and for the bonus to fill itself in based on the policy and type chosen. Unless Fire or Auto is chosen, in which case we need it to calculate 2% of the premium we enter. We have worked and worked on this and still cant get everything to work. We have tried the following formulas - =OFFSET(PolicyStart,MATCH(B5,PolicyColumn,0)-1,1,COUNTIF(PolicyColumn,B5),1) =IF(C5=,PolicyList,INDEX(PolicyColumn,MATCH( C5,TypeColumn,0))) =SUM(E5*2%) =vlookup(D6,A1:B3,2,FALSE) =VLOOKUP(D5,Policies!C3:D23,2,FALSE) And we have used the following informational links - http://www.contextures.com/xlFunctions02.html http://www.contextures.com/xlDataVal02.html We have uploaded the file to: http://www.savefile.com/files/1333831 Can anyone help us PLEASE? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Charts and Charting in Excel | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | Excel Worksheet Functions | |||
plot graph from multiple worksheet as embedded chart object on every worksheet | New Users to Excel | |||
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet | Excel Worksheet Functions |