Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird calc (braziliam VGBL IR - 1ª part)
I don't know how can explain, but I'll try to show what I want.
I have a sheet, something like this: Lin-A-B-C-D 1- 0-0-0-0 2- 100-100-0-0 3- 201-201-0-0 4- 303,01-303,01-0-0 5- 406,0401-406,0401-0-0 6- 510,100501-510,100501-0-0 7- 615,201506-615,201506-0-0 8- 721,3535211-721,3535211-0-0 9- 828,5670563-828,5670563-0-0 10-936,8527268-936,8527268-0-0 11-1046,221254-1046,221254-0-0 12-1156,683467-1053,007184-1000-103,6762825 13-1154,574019-1154,574019-0-0 .... On G2, I have =(((D2/(D2+B2))*(A$2-A$1))*F$2) G3: =(((D3/(D3+B3))*(A$2-A$1))*F$2) +(((D3/(D3+B3))*(A$3-A$2))*F$3) G4: =(((D4/(D4+B4))*(A$2-A$1))*F$2) +(((D4/(D4+B4))*(A$3-A$2))*F$3) +(((D4/(D4+B4))*(A$4-A$3))*F$4) G5: =(((D5/(D5+B5))*(A$2-A$1))*F$2) +(((D5/(D5+B5))*(A$3-A$2))*F$3) +(((D5/(D5+B5))*(A$4-A$3))*F$4) +(((D5/(D5+B5))*(A$5-A$4))*F$5) .... How can extendend the function to all the lines? Rodrigo Ferreira |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cross Reference Part Numbers | Excel Discussion (Misc queries) | |||
Limit drop down list and linking to other info | Excel Worksheet Functions | |||
I need help with an "If" Statement | Excel Worksheet Functions | |||
Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions | |||
Part Number/Qty Consolidations | Excel Discussion (Misc queries) |