500

Hey All, Quick question, I'm trying to calculate an ongoing IRR calc for a Private Equity Investment. For every period, I want to have an IRR calc up to that point. I need to somehow bring in the Fair Value of the fund on that date into the last cash flow of the IRR calc, otherwise the Cash...

Hi, I am trying to use Excel to calculate income tax. The tax system has a number of rates applied to each band as follows Lower Limit (H22) Upper Limited (I22) Rate (J22) Tax Free Allowance (G23) £0...

Hi, So my problem is: I have a list of 1 million rows of phone numbers I have a list of 500,000 phone numbers In both of these lists phone numbers are repeated so I cannot use conditional formatting to highlight duplicates. Basically I need to highlight any phone numbers/rows in the 1 million...

Hello All: I've searched for about a few hours and can't seem to find something that would help me do the following: I have a few files with over 1,500 images in each file. The files are copied from a network drive. When I email the files out, the images can no longer be viewed. If I copy...

Hi all, I manage a team of payroll with different salaries. I am looking for a solution where I can input the salary figure in a cell which it is matched against the conditions in the table below to output the correct Levy amount. Does anybody know of an efficient way to do this? Perhaps...

Hi, I'm trying to get a return in (H5) based on Column E multiplying by Column Q (100%, 130%, 150%). When I type the formulas individually they work, as IF(AND(E5>=O5,E5<p5,g5*q5) and="" so="" on="" for="" each="" of="" the="" other="" two="" returns.="" however,="" when="" i="" try="" to=""...

I have the following formula in cell G22 and it works fine and provides the correct answer...

I thought I would put my question in the subject line to make it easier to answer. I have large Market Cap numbers such as 2,500,000,000 and I would like them to be easier to read. So 2,500,000,000 could look like 2.5B or 2,500M something like that. I am sure there is a simple formula for this...

Hi All I am trying to use an IF statement in a VBA and am struggling! A section of the range (in columns E & F) is below: <colgroup><col><col></colgroup><tbody> 500,000 263,000 500,000 544,000...

i have a 100 transactions - 50 with a debit and 50 with a credit amount in 2 separate columns, i want to identify where each of the amounts land up in the following categories - <tbody> $0 - $2,500 $2,500 - $10,000 $10,000 - $50,000 $50,000 - $100,000 $100,000 - $250,000 $250,000 -...

Please help create a formula or macro based on the information below. Prefer to stay away from VBA. <tbody> <colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> This is the Annual contract Revenue This is the % Revenue Share that the Company gets to keep This...

I would like to create a template that could automatically compute the values below each time i change the value in in the yellow field <colgroup><col><col><col><col><col></colgroup><tbody> Sales Price 10,000,000 AMOUNT RATE INTEREST PAYABLE First RM500K A3...

Lets say in A2 thru A5 I have 4 different codes for one product all with different amounts represented in B2 thru B5. I then have 7 different people I need to allocate those amounts to in columns C1 thru I1 evenly against their order in C2 thru I2. What would be the algorithm that could be used...

Hi guys, I am trying to create sales projections by customer over the next few years and I am currently stuck. Example Data below: <tbody> Client name Salesman name Revenue per month Contract open Contract Close Customer A Salesman A 2,000 March 2018 December 2018 Customer B Salesman A...

Any help here would be appreciated. We have moved to the online subscription of Excel and my previous EVALUATE function doesn't seem to exist. I do not have any background in VBA, so I'm unsure of the possible solutions to my problem which appear in searches. I have some very large sheet that...

Hi I’m trying to work out an appropriate formula to automatically calculate commission. Our commission structure is below; <tbody> Commission band £12,500 Percentage 0 – 50% 2.5 50 – 75% 5 75 – 100% 10 100 – 150% 15 150 – 200% 20 200% + 30 </tbody> Commission is calculated...

Good evening, I have a column of data of about 2,500 rows. I am using the FORECAST function on all of the 2,500 rows at present to see how it works! I know that this number of rows pretty much makes what results FORECAST produces useless. Does anyone know what a good number of items or rows...

Hi All I feel like i'm being super stupid here. So in the sheet (i'm not allowed to attach files yet) there are two tabs Status and the pivot table In the pivot table there are groupings of account balances and i need to edit those groupings...

I have a situation with a table that I am using a hlookup. The problem is the lookup value might not be in the table and I will need to interpolate for the value that is not in the table. Below is a copy of the table 10,000 15,000 25,000 50,000 75,000 100,000 150,000 250,000 500,000...