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
1	Balance Used	Credit Limit	Usage %
2	$600	$750	80%
3	$350	$700	50%
4	$0	$1,000	0%

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:97px;"><col style="width:85px;"><col style="width:77px;"></colgroup><tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4