Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need help creating a formula for an excel sheet
I am working on a EMPLOYEE REIMBURSEMENT COST SHEET, I need to work with
Dollar amount to get to the total amount that is being reimburst. I always have the same dollar amount but diifrient totals. there a fucntion in excel that will tell me which colums to use. example A B C D (1)NEW INSTALL AIR $7.05 (7)ANALOG ADD OUT ST $6.90 (2)NEW INSTAL U.G. (8)UPGRADE SERVICE $9.85 (3)DIGITAL INSTALL $7.05 (9)SUB POLE/MID SPAN $9.55 (4)DIGITAL ADD OUT (10)REPLACE DROP (5)DIGITAL ADD OUT ST $7.05 (11)OUTLET REPLACE $3.60 (6)ANALOG ADD OUT (12)WALL FISH Normally under B1, its blank and under all dollar amounts is also blank. I ussually have a certain dollar that i need to get to example Dollar amount i need to get to is $28.05. Under B1 i would PUT 3 the value of this cell is $7.05 so 2x7.05=$21.15 Under D1 I sould PUT 1 the value of D1 is $6.90 If u add 21.15+6.90 = 28.05 is there a formula, that can tell me how man i have to PUT in each cell These below are what each cell is worth: (1)NEW INSTALL AIR $7.05 (7)ANALOG ADD OUT ST $6.90 (13)INST/ UPG GROUND $5.70 (19)CONVERTER RECOV $2.70 (2)NEW INSTAL U.G. (8)UPGRADE SERVICE $9.85 (14)INST MDU PREWIRE $6.60 (20)TRIP CHARGE $1.35 (3)DIGITAL INSTALL $7.05 (9)SUB POLE/MID SPAN $9.55 (15)DISCONNECT (21)CUSTOM HOURLY $4.15 (4)DIGITAL ADD OUT (10)REPLACE DROP (16)DOWNGRADE (22)RECO W/ WRECK DROP $0.75 (5)DIGITAL ADD OUT ST $7.05 (11)OUTLET REPLACE $3.60 (17)RECONNECT $1.95 (6)ANALOG ADD OUT (12)WALL FISH (18)RECO ADD OUTLET $6.30 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Multiple Pie Charts from Excel Sheet | Charts and Charting in Excel | |||
creating a formula on one sheet that uses results of formulas on o | Excel Worksheet Functions | |||
Creating Excel chart sheet using C# | Charts and Charting in Excel | |||
copy formula when creating new sheet | Excel Discussion (Misc queries) | |||
creating a combobox dynamically on an excel sheet | New Users to Excel |