Decimal problem

[planetpj]

Can any help me I am trying to copy over the last 2 digits over from cell C8 to D8 the problem is that when I copy the value over I get the remainer I only want to copy over 2 digits from the right. in other words 11.11 I want just .11 or 7.07 I just want .07

Thanks in advance

PJ

Staffing Master Form.xls
	A	B	C	D	E	F	G	H	I
8	PreK	200	11.11	1111111111111
9	K-1	43	1.72	72
10	Grades2-3	198	7.07	07142857142857
11	Grades4-6	54	1.93	92857142857143
12	Grades7-8	12	0.43	428571428571429
Sheet3

 

[bigbob]

=c2-INT(C2) Does this do what you want?
Big Bob

 

[fairwinds]

=MOD(C8,1)

 

[onlyadrafter]

Hello

Alternatively

=A1-TRUNC(A1)

 

[Ahampson9658]

use the mod formula in d8 : =mod(c8,1)

that will return the decimal remainder of a number

 

[ctrlaltdel]

Try this formula=VALUE("."&RIGHT(ROUND(D8,2),2)). It should work for your needs.

 

[Aladin Akyurek]

What if C8 is

3

0.8889

-45.567 ?

 

[planetpj]

Thank you. That did it

PJ