Excel spreadsheet formula to find percentage question

[Anonymous]

So what I'm trying to do is set up a formula in my Excel bills tracker spreadsheet to calculate how much $ I need to pay down to get to 30% of the credit line. I have a simple formula showing how much percentage I'm using for example =(C11/D11).

[AllZero]

Did you have a question?

[AllZero]

I'm a little rusty. If you're trying to find out what the actual value you need to be at 30%, Try =D11*30%

D11 being the credit limit I'm guessing?

[Anonymous]

Yes, what formula would I use to find how much I have to pay down to get to 30% of the credit limit of that card. If my credit line is $5000, and I'm using $3500 for example, how much $$$ would I have to pay down to get to the 30% threshold of that $5000 credit line.

[Anonymous]

I'll give it a try, thanks. I've a couple of different columns Balance(C), credit line(D), % being used(E), $ available(F)...in that order

[mikesonthemend]

My most recent is =(+H609*0.3)-G609

H609 is total available credit. G609 Is my total balance.

Of course you have to have your spreadsheet set up to total your limits and usage.

Yes, mine is a positive number, due to it showing me my cushion.

[wasCB14]

Or, to avoid negative numbers for low-utilization cards...

=IF(BAL>0.3*CL,BAL-0.3*CL,0)

[AllZero]

Thank you excel experts. I'm copying it.

[mikesonthemend]

I tried to give kudos but the button is not appearing.

[AllZero]

I'd give you a kudo but we're in a kudo free zone. They're anti-kudos here.