Extracting pence value from a currency

[maknae]

Hello,

I'm hoping someone could help, I need to be able to extract the pence from a currency, I thought it could be done by using RIGHT, however it doesn't work when there's no pence. Is there another method that can help me?

Any help would be greatly appreciated!

Thanks

 

[lrobbo314]

Book5.xlsx
	A	B
1	53.80	0.8
2	66.83	0.83
3	49.01	0.01
4	32.96	0.96
5	91.64	0.64
6	82.22	0.22
7	37.11	0.11
8	36.54	0.54
9	55.01	0.01
10	1.70	0.7
11	11.30	0.3
12	64.98	0.98
13	54.50	0.5
14	61.75	0.75
15	71.34	0.34
16	25.76	0.76
17	48.19	0.19
18	34.87	0.87
19	24.44	0.44
20	12.35	0.35
Sheet4

Cell Formulas
Range	Formula
A1:A20	A1	=TEXT(RANDARRAY(20,,1,99),"#,##0.00")
B1:B20	B1	=A1-INT(A1)
Dynamic array formulas.

 

[JEC]

.

 

[Fluff]

Another option

=MOD(A2,1)*100

 

[maknae]

Book5.xlsx
	A	B
1	53.80	0.8
2	66.83	0.83
3	49.01	0.01
4	32.96	0.96
5	91.64	0.64
6	82.22	0.22
7	37.11	0.11
8	36.54	0.54
9	55.01	0.01
10	1.70	0.7
11	11.30	0.3
12	64.98	0.98
13	54.50	0.5
14	61.75	0.75
15	71.34	0.34
16	25.76	0.76
17	48.19	0.19
18	34.87	0.87
19	24.44	0.44
20	12.35	0.35
Sheet4

Cell Formulas
Range	Formula
A1:A20	A1	=TEXT(RANDARRAY(20,,1,99),"#,##0.00")
B1:B20	B1	=A1-INT(A1)
Dynamic array formulas.

Another option

=MOD(A2,1)*100

Thank you both! Saved me hours if I thought to ask sooner

 

[Fluff]

Glad we could help & thanks for the feedback.