Whole NUmbers

[arlene_fool]

I have a formula to tell me how many months remaining in a job, i can format so you can only see the whole number, so 4 instead of 4.0329... but next to that cell i have a cell that calculates the apx revenue left in the job, i want it to multiply by the 4 not the 4.0329 etc. is there someway to make it an actual whole number, or to just look at the whole number?

Excel Workbook
	A	B	C	D	E	F
1		March-11
2	Rental End Date	May-11		rest of the year		should be
3	01-Jun-11	$ 10.00	0.07142857	$ 0.71		0
4	01-Jul-11	$ 10.00	1.14285714	$ 11.43		1
5	01-Aug-11	$ 10.00	2.25	$ 22.50		2
6	01-Sep-11	$ 10.00	3.35714286	$ 33.57		3
7	01-Oct-11	$ 10.00	4.42857143	$ 44.29		4
Sheet1

Excel 2010

Cell Formulas
Range	Formula
C3	=(A3-($B$1+90))/28
C4	=(A4-($B$1+90))/28
C5	=(A5-($B$1+90))/28
C6	=(A6-($B$1+90))/28
C7	=(A7-($B$1+90))/28
D3	=C3*B3
D4	=C4*B4
D5	=C5*B5
D6	=C6*B6
D7	=C7*B7

 

[Jonmo1]

You can use the INT function to use just the whole number.

=INT(C3)*B3

 

[MrKowz]

Put the formulas in column C inside of an INT function:

For example, change C3 to: =INT((A3-($B$1+90))/28)

 

[arlene_fool]

figures it would be something simple, but a formula i have never used before. thank you!!