topic Re: Excel spreadsheet formula to find percentage question in SmorgasBoard

Excel spreadsheet formula to find percentage question

Anonymous — Mon, 20 Jan 2020 04:53:16 GMT

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).

Re: Excel spreadsheet formula to find percentage question

AllZero — Mon, 20 Jan 2020 04:54:48 GMT

Did you have a question?

Re: Excel spreadsheet formula to find percentage question

AllZero — Mon, 20 Jan 2020 05:19:19 GMT

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?

Re: Excel spreadsheet formula to find percentage question

Anonymous — Mon, 20 Jan 2020 04:58:56 GMT

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.

Re: Excel spreadsheet formula to find percentage question

Anonymous — Mon, 20 Jan 2020 05:03:44 GMT

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

Re: Excel spreadsheet formula to find percentage question

mikesonthemend — Mon, 20 Jan 2020 05:07:47 GMT

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.

Re: Excel spreadsheet formula to find percentage question

wasCB14 — Mon, 20 Jan 2020 05:11:31 GMT

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

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

Re: Excel spreadsheet formula to find percentage question

AllZero — Mon, 20 Jan 2020 05:13:03 GMT

Thank you excel experts. I'm copying it.

Re: Excel spreadsheet formula to find percentage question

mikesonthemend — Mon, 20 Jan 2020 05:13:46 GMT

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

Re: Excel spreadsheet formula to find percentage question

AllZero — Mon, 20 Jan 2020 05:15:49 GMT

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

Re: Excel spreadsheet formula to find percentage question

Anonymous — Mon, 20 Jan 2020 05:24:04 GMT

I really appreciate it😁👍👍, it works.

Re: Excel spreadsheet formula to find percentage question

AllZero — Mon, 20 Jan 2020 05:35:36 GMT

Congratulations on your success!