Hello!
I would really LOVE and be forever grateful if someone could help me create a spreadsheet that I have in mind. r even tell me if what I want to do isn't possible?
Or, because creating spreadsheets isn't my cup of tea...if you already have one that touches on my points below and want to share 
Basically this is what I am looking to do, which involves some formulas that I don't know how to do (in bold).
Column A - Card Name
Column B - Credit Limit
Column C - Current Balance
Column D - Utilization - Ideally, this would be a formula that would show my utilization as a percentage calculated from Column B and C.
Column E - Utilization Goal - Ideally, this would be a formula that would show how much needs to be paid in order to have Utilization below 20%
Then, for Rows, I am looking to have:
Bottom of B - Total Credit Limit
Bottom of C - Total Current Balance
Bottom of D - Total Utilization (as a percentage)
Bottom of E - Total Utilization Goal
This is actually quite simple. The most challenging part is creating a formula that calculates your Utilization Goal.
Assuming the layout you want is unchanged, this formula will work: =IF(D3<=20%,"OK",ABS(B3*20%-C3))
@toothgrind3r wrote:Hello!
I would really LOVE and be forever grateful if someone could help me create a spreadsheet that I have in mind. r even tell me if what I want to do isn't possible?
Or, because creating spreadsheets isn't my cup of tea...if you already have one that touches on my points below and want to share
Basically this is what I am looking to do, which involves some formulas that I don't know how to do (in bold).
Column A - Card Name
Column B - Credit Limit
Column C - Current Balance
Column D - Utilization - Ideally, this would be a formula that would show my utilization as a percentage calculated from Column B and C.
Column E - Utilization Goal - Ideally, this would be a formula that would show how much needs to be paid in order to have Utilization below 20%
Then, for Rows, I am looking to have:
Bottom of B - Total Credit Limit
Bottom of C - Total Current Balance
Bottom of D - Total Utilization (as a percentage)
Bottom of E - Total Utilization Goal
Your spreadsheet will look something like this:
Hi,
I am new to the forums but I can help. I've actually created a spreadsheet like this (with more details) for myself almost a year ago.
I can send to you via pm if you'd like in your format. One suggestion: moving the column totals toward the top of the spreadsheet will make the overall totals catch your eyes quicker. It's helpful as you add more line items to the rows.
