seeking formula

B

BIJU.M.S.

Cell (A1) hv value 1,322.50

My question is i want to know by a forwmula instead of
mannual calculation-
1)calcukate how many 1000 are there in 1322.50 ?Ans = 2
then balance value = 322.50
NEXT
2)calculate how many 200 are there in 322.50 ? Ans = 1
then balance value = 122.50
NEXT
3)calculate how many 100 are there in 122.50 ? Ans = 1
then balance value = 22.50
NEXT
4)calculate how many 10 are there in 22.50? Ans = 2
then balance value = 2.50
NEXT
5)calculate the balance coins = Ans = 2.50

please help me to find this calculation by applying
formula.

awaiting yr answer soon
thanks & regards
BIJU.M.S.
 
F

Frank Kabel

Hi
use the functions INT and MOD for this. e.g.
=MOD(A1,1000)
will return
322.50

and
INT(A1/1000)
will return 1 (I assume you made a typo in your example).
 
Top