000

Hi. I'm trying to write a formula to calculate the cost of various employees spread over months (or quarters) so I can create graphs of the annual cost impact to a business. They all have different contract start and end dates along with varying daily rates of pay. Can anyone help me please? If...

I need to examine a content string and determine if there is a comma present. Seems like the easiest thing in the world, but I'm really stumped at the moment. I will add the formula I'm currently using in the code window, along with my results. It's the cell containing "1,000" that's giving...

I have these kind of data on a1 <colgroup><col></colgroup><tbody> 250,000 48,000 50,000 35,000 40,000 60,000 35,000 230,000 35,000 16,000 15,000 814,000 45,000...

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

Hello, I have a folder with over 3,000 xlsx files. These files contain several tabs with specific names. I am trying to locate which of those files do not have a tab with the name "DOWNLOAD". I do not want to have to open all 3,000 files and identify which ones do not have this tab. Is there any...

Formula on c29 if b6 is KASUMBALESA or LUBUMBASHI then plug fare as 480,000

Hi All, I need some assistance please. i'm using excel 2016. Col W contains a revenue amount Col U contains the currency used Col X i need to contain the result of converting the rev amount in col w & col U so for instance if col W is 50,000 col U is GBP col X should be 46,000 ( 50,000 *...

I have a 4 digit padlock like this one that I have forgotten the number to. I can buy a new lock for ~$15 but I'd rather try & unlock the one I have. I'd like to create an excel sheet that contains all the different possible combinations (10,000 of them). That way, I can keep track of the...

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

Hello, I am trying to create a model where a portion of revenue is consumed each month starting on the contract start date. The amount of consumption each month would be an input and could be changed if required. In the below example 85,000 is total revenue, 25,000 is consumed for 3 months. On...

I've seached high and low and cant seem to get this to calculate correctly so i'm hoping someone on here can help figure this out! My company uses a tiered commission system that pays out as follows. $0-500,000 0.91% commission $500,000-800,000 1.35%...

Hi All, What would be the best formula to use to get the data from the below.... Im looking at just grabbing data in the [ ]'s from over 5,000 lines of data Roshani [ RL52486 ] I'm looking to just get RLr2486 Ozlem [ OK51419 ] I'm looking to get OK51419 Robert [ RConville ] I'm looking to...

I am looking to distribute an amount over several employees as a bonus. I have a different percentage I would like to give each employee. How would I go about this? For example, I want to distribute $1,000 over 5 employees. TIA!

I know I've done this a hundred times, but it must be late. Need formula to produce the required monthly payment to reach $16,000. 15 yrs x 12 payments Earning 8.2% annually Thanks!! Mike

In column "B" i have 73,000 rows of strings of text ranging from 10 to 22 characters per cell. I need to take only the first 3 characters and put them in the cell in column "C". for example I have 303WXF987V-8"-15BX7 in cell B3....in cell C3 I need to have only the first three characters...

I'm trying to reverse engineer hours based on a team with various %s totaling 100%. In the end, hours X each individuals known Rate will all sum to be $175,000. I have a program that does this but I'm trying to replicate in excel. First table below is completed in the program and every time I...

hi all can someone explain the following formula in simple terms please - what is this achieving ? =SUM(F4*(1+E4)^D4) F4 = £547,000 (Total set up costs) E4 = 3% (Inflation) D4 = 5 years (Life) so the above formula result is £634,123

I don't even know where to start. Can someone point me in the right direction? I have a sheet similar to the example below and what I need is for excel to find the column to the far right that matches either the "Start Date" or "Expiration Date" and fill in the amount found on "Price per...

Hi, First time i have signed up to a forum, I can't seem to find an answer online, and have spent hours trying to figure this out. I need a spreadsheet that calculates varied rates of commission. If a sales person bills £45,000 (above a target threshold), they will be paid on the following...

Hello Add New member here and trying to work with excel. I am sorry if I make mistake the way, I am really new to this. What I am trying to do is: Inter link two order books ( as in an exchange) of two currency pairs; using price and volume. I have tried several times to work out a formula...