Card Utilization

[darthmactis]

Hello, I'm trying to get the utilization of all of my cards. I know the formula is (Amount Owed / Credit Limit * 100) but how do I put that n Excel?

Thanks,

 

[Michael M]

Exactly as you wrote it !
Are the amount owed and Credit Limit in cells ??
So, assuming amount owed is in A1 and Credit limit is in B1

Book1
	A	B	C
1	100	50	200
Field

Cell Formulas
Range	Formula
C1	C1	=A1/B1*100

 

[darthmactis]

Exactly as you wrote it !
Are the amount owed and Credit Limit in cells ??
So, assuming amount owed is in A1 and Credit limit is in B1

Book1
	A	B	C
1	100	50	200
Field

Cell Formulas
Range	Formula
C1	C1	=A1/B1*100

Thanks for the help!!! not sure what i was doing wrong but did the same in a new cell and it worked fine TY!!

 

[Michael M]

Glad it worked....