Formula Help

[Tivpine Anande]

VoteBook Dummy.xls
	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG
1
2	3,005,987.89
3
4												Treasury Book 46 (R)
5		S.W./A.I.E./R.I.E. Number:								NJC2/2/02/Vol.1/1/103
6		Amonut Available for Expenditure:								First Quarter Allocation		N	20,000,000.00
7										Second Quarter Allocation		N	25,000,000.00
8										Third Quarter Allocation		N
9										Fouth Quarter Allocation		N
10		LIABILITIES								Total Allocation		N
11
12	Incured (9)			Cleared (10)			Total Outstanding (11)			Remarks (12)		Balance Available (13)			Line No. (14)	Line No. (15)
13										First Quarter Allocation 2009		20,000,000	00
14
15	3,005,987	0					3,005,987	0		ABC Ltd		16,994,013	13
16
Road Motor Vehi.

Hi All,

I need help anyone, i have this figure 3,005,987.89 to be deducted from 20,000,000.00, i belive i should have 16,994,012.11.

This is my problem - i have this formula !=INT(R2) in cell R15 which is working perfectly, what i want to also do is have the the decimals subtract themselves and post to say Cell S15.

Also AC15 is derived this formula !=AC13-R15 which should also equal 16,994,012.11.


Thanks Guys

Tivpine

 

[Tivpine Anande]

Jeff,

Am looking for 16,994,012 in AC15 and 11 in AD15. The idea of AC15 is 20,000,000.00-3,005,987.89=16,994,012.11.

Once again thanksssssssssssssssssssssssssssssssssssssssssssssssss

Tivpine

 

[jeffreybrown]

Will this do it...Just replace the 20M and the 3M with the appropriate links in your spreadsheet setup. Maybe not the most elegant, but it gives you what I understood your last post to ask.

Sheet2

<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 89px"><COL style="WIDTH: 40px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD> </TD><TD>AC</TD><TD>AD</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">15</TD><TD style="TEXT-ALIGN: center">16,994,012</TD><TD style="TEXT-ALIGN: center">11</TD></TR></TBODY></TABLE>
<TABLE style="FONT-SIZE: 10pt; BORDER-LEFT-COLOR: #00ff00; BORDER-BOTTOM-COLOR: #00ff00; COLOR: #000000; BORDER-TOP-STYLE: groove; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-RIGHT-STYLE: groove; BORDER-LEFT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-RIGHT-COLOR: #00ff00; BORDER-BOTTOM-STYLE: groove"><TBODY><TR><TD>Spreadsheet Formulas</TD></TR><TR><TD><TABLE style="FONT-SIZE: 9pt; FONT-FAMILY: Arial" cellSpacing=0 cellPadding=2 border=1><TBODY><TR style="FONT-SIZE: 10pt; BACKGROUND-COLOR: #cacaca"><TD>Cell</TD><TD>Formula</TD></TR><TR><TD>AC15</TD><TD>=TEXT(SUBSTITUTE(LEFT(20000000-3005987.89,FIND(".",20000000-3005987.89)),".",""),"0,000,000")</TD></TR><TR><TD>AD15</TD><TD>=RIGHT(20000000-3005987.89,2)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>

Excel tables to the web >> http://www.excel-jeanie-html.de/index.php?f=1" target="_blank"> Excel Jeanie HTML 4