balance

Hello everyone. I have a specific goal I am trying to achieve and I'm hoping you can help me. My Goal: I am using a basic loan amortization schedule spreadsheet to tract a loan. I want to add a dynamic cell that displays the current balance of the loan based on the current month. My...

Hello All, I'm a fairly light excel user and am looking to do the following with the set of data below: Beginning Balance BofA: $1,000 Beginning Balance WF: $1,500 <tbody> Amount Type -2 BofA 10 Wells Fargo 12 BofA -5 Wells Fargo </tbody> I'm looking to have a running balance for 2...

I am trying to set up a formula where it looks at a cell and decides if there is enough funds to transfer ..if not pull more from another place. Only transfer enough of what is needed. See example .. if you look at line #1 there is $874K is available I want to transfer up to the amount I...

Hi, I am using Excel 2013. I have 2 different spreadsheets with 2 variables that I need to sum the balance. Notice the Main spreadsheet has the same account number for all entities. However, the Lookup spreadsheet has multiple accounts and entities. I need to sum the balance by entity and...

I have the following array formula below, which gives me the correct result =INDEX(D:D,MATCH(1,SEARCH("Grand*",A:A))) ]/code] Alt+Shift+enter I have tried add text to this, but get message opening or closing Parenthesis missing [code] ="The Balance on a/c 975415 is...

Hello to all, I need to find a formula that will take two dates and two different time ( time in and time out) and subtract them to give me the time what was the balance used I.E Date time in date completed time out time used 5/1/2018 10 AM 5/2/2018 11: PM...

I have a huge spreadsheet that updates monthly and I want to insert a column at the beginning for ease in reconciliation of the current balance and current AD. See example below...I basically want to update the date field on a monthly basis and get the current balances populated. Thinking this...

Hi, I'm hoping someone can help with first attempt at an array formula. I have a bank statement in the form: <tbody> Index Date Balance 1 05/01/2018 100 2 07/01/2018 150 3 07/01/2018 142 4 07/01/2018 145 5 09/01/2018 500 </tbody> I would like to be able to type a date into a cell...

Hi I want to use don't chat for these values monthly expense = 500 monthly income = 1200 balance = 700 Which values should go to doughnut chart? I want to do it like progressing chart. whenever the expense reaching the income the chart move further etc Thank you so much.

Hello All, I am trying to create a formula to reduce sales from a specific purchase until that full purchase amount is then sold. I then want the formula to look at the next purchase and start to reduce that amount etc. The sheet is similar to as follows: On one tab ('Purchases') I have all...

Hello All, I am trying to create a formula to look at the following: On one tab ('Purchases') I have an amount of product pre-purchased. <tbody> A B 1 Amount Balance 2 500,000 X 3 250,000 X </tbody> On another tab ('Product Sold')I have a list of all the products used as follows...

Hi team. I have 3 sheets.sheet1(summary).sheet2(TB) and sheet3(balance sheet). In sheet3 I have one account called 2930-retain earnings current.the total balance of 2390 should be matched with TB ledger account 3000 to 9999 balance. The results I want in sheet1 .. give me some formula to get...

Dear all, Please advise, is there any way to calculate the following task with excel? In document https://docs.google.com/spreadsheets/d/18wuUFxV_0p2Cr0G8xA4O2e0qi_lW0K060vM6RnDnCzU/edit?usp=sharing, There are 3 players. We are playing pingpong games. Each day we play two tournirs. In each...

Hi, I'm new to this forum, so I am glad I found you all and hope you can help. I have a workbook where I record monthly stock data. this data is linked to other worksheets and some other workbooks where I have formula's to do various calculations. The way I link them is using the "=" and...

I am attempting to bulid a formula that will determine rate on an "end of the period" loan where the only knowns are: Starting Balance Term and frequency of payments Number of payments made Current Balance For example: On a $100,000 30yr mortgage, 12 payments have been made, and the current...

Hi guys, Someone on here will probably find this dead easy. I want to set up a spreadsheet, that will tell me how much money I will still have before I get paid again. Basically, it would show the current date and I would input the dates and amounts of when money comes out of my bank. So, for...

Hello, I need some assistance in balancing a decision tree. Instead of showing what to do with a set of inputs, I want to be able to balance the output to zero if the inputs are out of balance. It's probably best with an example... A1 B1 C1 -2 A1 B2 C2 -2 A2 B2 C2 -1 A2 B3 C2 -1 A2...

Hi, I am trying to create a formula to calculate the value of a stock portfolio after a series of annual returns/(losses) and after withdrawing an annual amount based on a % of the original balance. For example, I have an opening balance of $100 and want to withdraw 4% of the original balance...

I am looking for a formula to keep a running balance that accounts for every other row being blank. The Balance starting cell is H3 The starting row for the credits and debits is ROW 5 I would like to keep the running balance on the even ROWS with the first cell being ROW H6 and then every other...

I am trying to type words in to a cell and also add a number by way of linking to a cell reference and then add more text after. e.g. I want the outcome to be Your balance at 31 May was 200,000. Please check if you have a difference. I start off with "Your balance at 31 May was "&C3&" Please...