J
jennyandalize
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
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