capital

Hello, I want to create a spreadsheet where I start with a fixed value, say £100,000 which will grow at a rate of (say) 4%pa for 10 years when I will start drawing down capital at 10%pa. This part of the calculation is easy but what I then want to do is to apply the original 4% growth to the...

Hello! Requesting help for Conditional Formatting. Example in table below shows desired results. CAPITAL ONE is paid off in bottom table. When excel sees the a value higher than zero in the PAYOFF AMOUNT column I want the CREDITOR and PAYOFF AMOUNT cells to display with a red font...

Here are the sample text: Input: 1. AbST/1234342 2. Y_sRR/666 3. B.RE/1234 Output: 1. AST 2. YRR 3. BRE Basically I need a formula to get the first three capital letters before the slash and disregard lowercase and symbols.

Hi Is it possible for me to handle receipt allocations to a loan in excel or access? <colgroup><col><col><col><col><col><col><col><col><col><col span="3"><col><col span="2"><col><col></colgroup><tbody> Borrower Name Agreement Number Transaction Reference User Agreement Date Repayment Method...

Hi everyone, Just had a nightmare download, and need to get this out asap. hope some can help me all my data has come in in one cell per row It looks like this <colgroup><col></colgroup><tbody> "127FsFredsmith(257)" </tbody> Now what I need is 3 columns "127" "Fs" "Fredsmith(257)" so the...

Hi there, Can anyone see where I am going wrong please? Basically, if N80 is >0 return "Enter Capital Gain XPA Code" if N80 is <0 return "Enter Capital Loss XPA Code" Once the code is entered, I want the "Enter" to be removed from the description so, If N80>0 and N84>0 return "Capital Gain XPA...

Iwant the "Name" field in my table to contain only capital letters. How to do it?

Hi all, Could realy do with some help. The below formula extracts the text up until the 2nd capital letter, like ThompsonTaxi and it will return Thompson, great. But it is not picking up names with an apostrophe or double barrelled names. I need a formula that starts from the right and will...

Hi all, I am trying to extract a surname from a text string, something like thisSmithTaxi. The array formula I am using (and shamelessly nicked off this forum)is below, I think the formula is extracting the characters up until there is anew capital letter in the string...

Hi! I have a code but it doesn't do what It should :D For h = 0 To k 'lets suppose from 1 to 4 capital = 400 * 3 ^ h ossz = 0 + capital Next I would like to sum up 400, 1200, 3600, and 10800, but the "ossz" variable is always the latest value of capital. So at the...

I need to count the number of roles where either Capital or Expense > 0 (so if Cap+Exp > 0 then count it) I am having difficulty with the equation portion <colgroup><col><col span="2"><col span="3"></colgroup><tbody> A B C 1 Role Capital Expense 2 PM $ 4,500 $ 2,500...

Hi guys. I'm looking for an Excel-based game "Capitals of Europe" (or sth like that). There was a map of Europe (just the outline of the countries) and the game would ask you questions like: "Where is the capital of Romania?" And then you would indicate a spot on the map and click and a dart...

This is my first post so please work with me a bit. I am trying to use two variables in the same column (different rows, one is a header and one is a list item) to return a number in the corresponding row of the second variable (list item) in a spreadsheet. This data is also in a pivot table...

I would like to simulate the growth of my capital invested in a stock. Suppose these conditions: - initial capital of 100.000$ (cell A1 = 100.000$) - growth rate of +100%/month (cell A2 = 100%) (I know that it's too high to be realistic, it's just to make the numbers of my example simple to...

I am using the following formula. ="Beginning Balance "&TEXT(AE10,"$#,##0")&" Capital Account Estimated Balance " I want it to show up in the cell on two lines. Like ALT ENTER does. I want the " Capital Account Estimated Balance " on the second line.

I have an Excel Table (Excel 2016) that I use this array formula to count the number of filtered rows of unique values. =SUM(IF(FREQUENCY(IF(SUBTOTAL(3,OFFSET(A29,ROW(A29:A11459)-ROW(A29),0)),A29:A11459),A29:A11459),1))-1 So it counts the unique numbers in Col A with each filter. What I...

I'm interested in a macro that removes an entire row if the cell in column "A' contains "II", and the II needs to be case sensitive to capital letters. Also if the macro could ignore the first row which is headings. Thanks for your help, greatly appreciated.

Hi, can anyone tell me how to get the delta symbol to stop showing up as a capital D? Thanks, Rick

Hi, I have two related issues regarding the extraction of a portion of a text string which can be noted as 1) and 2) below. 1) In the case where I have some example inputs of R6.300, R10.300 & N10.300, I would like to be able to extract the numerical value proceeding the capital letter - in...

Hello All, This is my first of likely many questions on this forum, as my excel skills are far too basic for my liking and I am keen to better them. I am given a task where I have a row of various different addresses for head offices of public companies. I just need the US state of where they...