Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird calc (braziliam VGBL IR - 1ª part)
=SUMPRODUCT((($D$2:D2/($D$2:D2+$B$2:B2))*($A$2:A2-$A$1:A1))*$F$2:F2)
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rodrigo Ferreira" wrote in message ... 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 |
#2
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird calc (braziliam VGBL IR - 1ª part)
Hi Bob,
The result is not the same: 1- 2- 0 3- 0 4- 0 5- 0 6- 0 7- 0 8- 0 9- 0 10-0 11-0 12-36,28669887 -- This is the correct result 13-0 -- Rodrigo Ferreira "Bob Phillips" escreveu na mensagem ... =SUMPRODUCT((($D$2:D2/($D$2:D2+$B$2:B2))*($A$2:A2-$A$1:A1))*$F$2:F2) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rodrigo Ferreira" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weird calc (braziliam VGBL IR - 1ª part)
=SUMPRODUCT((($D19:D19/($D19:D19+$B19:B19))*($A$9:A19-$A$8:A18));$F$9:F19)
Thanks Bob!!!!!!! -- Rodrigo Ferreira "Rodrigo Ferreira" escreveu na mensagem ... Hi Bob, The result is not the same: 1- 2- 0 3- 0 4- 0 5- 0 6- 0 7- 0 8- 0 9- 0 10-0 11-0 12-36,28669887 -- This is the correct result 13-0 -- Rodrigo Ferreira "Bob Phillips" escreveu na mensagem ... =SUMPRODUCT((($D$2:D2/($D$2:D2+$B$2:B2))*($A$2:A2-$A$1:A1))*$F$2:F2) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Rodrigo Ferreira" wrote in message ... 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 |
Reply |
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) |