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 |
All times are GMT +1. The time now is 07:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com