What is this Madness? Weird Average and Sum results
What is this devil math? What am I missing? The darker green value and blue value should match. I checked for truncated decimal values, even rebuilt the sample to ensure nothing was weird about the original cells. This is not an insignificant difference for what I'm doing, and I don't understand why these aren't lining up. I'm sorry if I'm missing something simple, but please, help!
I need Help with Cell Formatting to be able to copy
I have a number in a cell 2022 NET 260 $ 241.32 and I want to get the NET of that value by taking the 260 and multiplying it by another cell Monthly Percentage 7% and subtracting that number from the original 260. I then want to be able to copy the formula and paste it down the column yet making sure that the 7% Cell remains constant unlike the 260 cell. I forget how to do that. Help
Combine data from 2 columns into 1 column
I want to do this, but with 2 columns of data. We have a sheet with area codes in one field and phone numbers in another. I need the 2 pieces of data in one field for a list of 500 phone numbers. Do I have to do them one at a time???? Combine data with the Ampersand symbol (&) Select the cell where you want to put the combined data. Type = and select the first cell you want to combine. Type & and use quotation marks with a space enclosed. Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.Margin calculator for media budget
Hi, I need help formulating a calculator where the 'Fixed Margin' is separated out from the total budget. My calculation needs to add a buffer to the margin as the platform where this is inserted will reduce the nominal margin when you also include a flat cpm fee as it increases the total amount billed. For example, if margin was 20% of $10,000 then the remaining budget left should be $8,000. However, when you add a rate card on top and deliver x amount of media impressions, the effective margin as a percent of total cost is always going to be less than the nominal margin percentage. Example: Total cost: $10,000 Margin fee: 20% Flat CPM rate: $1.50 Impressions: 2,000,000 then this would lead to this: Media Cost $5,600 Margin Fee $1,400 Flat CPM rate ($1.5) $3,000 Total $10,000 Ideally, I would like to ensure the margin is kept at $2,000 (20%) so need help creating a formula that will raise the margin to a % that keeps your nominal margin rate whilst factoring the flat cpm fee and the impressions served.
Providing info on tab, based on other tabs with parent child relationship.
Hi, This post/question is based on a simplified verion of a security-matrix that is te be audited in the company and also audited against the real time security-tables in external system. I changed things to recognizable terms. What would be the best way to solve the task below? We have a PDF-image based on tab "FuntionRole_matrix" that is periodically audited against the actual situation. Thati is why this tab is not edited by hand but partially based on two additional tabs that are provided from another third party system. These additional tabs are "RoleTask_matrix" and "TaskTool_matrix" In Tab "FunctionRole_matrix" we manually fill the departments, job-titles per department and de roles assigned to the specific job-title. In Column D we have a picklist of all the known Roles, as found in tab "RoleTask-matrix" After choice the Role_ID is provided in column E. (via cell function: =X.ZOEKEN(D2;RoleTask_matrix!$A$2:$A$6;RoleTask_matrix!B$2:B$6;"Not found" (=V.Lookup in dutch Excel verison + semicolons different from english functions) The Top row is filled by a lookup of all the possible tasks. In the FunctionRole_matrix we provide insight in de assigned tasks within a role by a lookup-function in tab "RoleTask_matrix" (via cell function in topline: =X.ZOEKEN($D$1;RoleTask_matrix!$A$1:$A$1;RoleTask_matrix!E$1:E$1;"Not found") (and for cell F2 etc.. the X is set by =X.ZOEKEN($E2;RoleTask_matrix!$B$2:$B$6;RoleTask_matrix!E$2:E$6;"-")) Since we have to provide full insight in the relation between the jobtitle, the tassk within te job en the tools/matrials provided for the job we show the tools/matrials provided on the same line as the role in de FuntionRole_matrix. So that we can provide a signed PDF-copy of this excel-tab. The tools provided must be determined by looking for the, via lookup determined, X-es per role. When an X is detected we have to determine de task provided in the topcel of that row. With this task-ID value we need to search in the tab "TaskTool_matrix" and look for the checked tools/materials that should be provided for every jobtitle that has that task. Roles can overlap on tasks and this can also be the case for the tools/materials. We just need an X on FuntionRole_matrix kolom AB etc.. to see what has to be provided to a person in every job-title. Since there is no VBA-knowledge present i cannot bring this Excel sheet live with a button that sets all the X-es as of column AB. Personally i can do it, but withoud future support this cannot be the case. The solution needs functions in cells to provide the information. I guess it must be a combination of IF THEN ELSE with nested VLOOKUP functions. And we have to look for an X that is provided by a function in the cells. So possible some indirect value comparison needen instead of looking for character X in cell. but i have no clue about how to do it. Hope someone has the solution. Very grateful for response. I can provide the excelsheet via a PM. Seems like i cannot attach it to this post Best regards, MikeExcel - COUNTIF Function
Happy Friday! I am trying to use the COUNTIF Function on a worksheet that tracks how much liquid chlorine is used at 3 different water wells each month, each well having 2 chlorine cylinders. I'm not sure if my brain is fried from reading/watching all kinds of videos for the past 3 hours and trying to follow their instructions, but any time I put in a formula, I get a pop-up saying I've entered too many arguments. Even if I enter individual cells and use only the 3 that it highlights for me (more than 3 does not highlight). I've attached a screen shot of the worksheet (Figure 1) and have highlighted the area I'm trying to figure out. As you can see, it will be for multiple dates, on multiple lines, going through to the end of the month, with the total chlorine (CL2) tallied up on the right hand side. Chlorine tanks are changed out quite often and each tank begins at 150, depleting down to 0. Figure 2 shows a screen shot of what I'm getting when trying to enter the formula. Am I misunderstanding how the formula works or am I using the wrong formula all together? Figure 1 Figure 2
Formula for adding multiple sheets
I am trying to add multiple things across multiple sheets. example : On sheet one, I have column a date, column b check number, column c name of place, column d category, column e withdrawal amount, column f deposit amount, column g balance, column h status (cleared or pending). this same information in on sheets 2,3,4,5 and so on. I want to create a sheet that will tell me how much I have spend with each name of place (column c). let’s say sheet one looks like this 3/23 (date) 777 (check number) John Doe (name of place) 2.00 (withdrawal amount) etc. 3/23 778 John Doe Jr. 3.00 etc sheet two 3/24 666 Joe Doe Jr. 3.00 3/24 668 Joe Doe 4.00 on my total sheet with the amount I have spend with each person/place to look like this Joe Doe — 6.00 (from the 2.00+4.00) Joe Doe Jr — 6.00 (from 3.00+3.00)
MISSING FUNCTIONS THAT I PREVIOUSLY HAD ACCESS TO
I just switched macbooks and opened my excel to discover I had a few missing functions: MAXIFS, SEQUENCE. This is not a problem regarding the software as mine is MICROSOFT365 and I used the same account previously. Is there any way I can gain these functions back! Thank you!
