Calculate Percent of total used from total available.

[Harvnet]

I know this has to be simple, however have multiple projects and just can't clear thoughts to get this right.

Here is what I am trying to do:

I want to find the percentage of credit used of available credit.

Example: On your credit report, there is a utilization of credit lines. Your Credit limit and the amount of your balance.

I want my monthly budget to give me up to the minute Utilization Percent. Everything I have tried, isn't working.

If my Current Balance is in C1 and Credit Limit is in D1, I want the percent of Utilization in E1.

So far here is my formula is in E1: =((D1-C1)/D1*100)

It is like (D1) 750.00 Credit line, I have a Balance of (C1) 600.00 the result is (E1) 20 (It should be 80)

It is working for others, like (D2) 70.00 Credit line, I have a Balance of (C2) 350.00 the result is (E2) 50

But if I have (D3) 1000.00 Credit Line, With a Balance of (C3) 0.00 the result is (E3) 100 when it should be 0

I know it is just moving my calcs, but don't have the brain power right now

Any help is greatly appreciated. Thanks, Greg

 

[StephenCrump]

I assume you mean:

C2: =A2/B2

1

*	A	B	C

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:97px;"><col style="width:85px;"><col style="width:77px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: right"]Balance Used[/TD]
[TD="align: right"]Credit Limit[/TD]
[TD="align: right"]Usage %[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]$600[/TD]
[TD="align: right"]$750[/TD]
[TD="align: right"]80%[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]
[TD="align: right"]$350[/TD]
[TD="align: right"]$700[/TD]
[TD="align: right"]50%[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]
[TD="align: right"]$0[/TD]
[TD="align: right"]$1,000[/TD]
[TD="align: right"]0%[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4