LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 79
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cross Reference Part Numbers Chuck N Excel Discussion (Misc queries) 2 July 28th 06 06:25 PM
Limit drop down list and linking to other info Intuit Excel Worksheet Functions 13 February 2nd 06 09:48 PM
I need help with an "If" Statement Whayne Excel Worksheet Functions 3 July 20th 05 09:25 PM
Transpose unique values in one column/mult. rows into a single row Wil Excel Worksheet Functions 1 May 22nd 05 08:52 AM
Part Number/Qty Consolidations [email protected] Excel Discussion (Misc queries) 2 February 6th 05 09:21 PM


All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"