math

Hi Everyone. Maybe you can help me with this question. I have here an example with this range of data. Data below is the RAW. What I want to do is to get the Overall Score from the Unique Column which is the Description and Month containing what Range there Grades are. So for Instance, I...

Ok, so I am trying to send out letters to students showing them how many missing assignments they have. I want to transfer this information using a mail merge. Is this possible? Some students have 2 some have 4 or 5. I want to transfer what assignments they are missing. Here is an example...

My formula is : =DATEDIF(O2,AL$1,"y")&" years, "&DATEDIF(O2,AL$1,"ym")&" months, "&O2-DATE(YEAR(O2),MONTH(O2),1)&" days" Where O2 is the hire date and AL$1 is today() The formula works, kinda. It isn't doing the math correctly. I have a person who started exactly a year ago and it is 2...

All, I have this equation =SUM(IF(ISNUMBER(B4:B200),IF(MONTH(B4:B200)=MONTH(R3),--((C4:C200)))) B is a list of dates R3 is a drop down of months C4 is data or numbers What I need to do is for February, I need to sum feb then sum Jan and then I need to do this math (What I want = ((Feb+Jan)-Jan)...

1. This subject was already answered before: https://www.mrexcel.com/forum/excel-questions/911306-managing-autocorrection-excel.html?highlight=math+autocorrection 2. I used it in previous versions but it seems that it does not work in Excel 2016

Hello, I am struggeling with the following problem. I tried to calculate the amount of casenumbers for each worker (1 to 1000 cases) by taking their weekly work-hours into account. I tried to let Excel do the math without rounding any numbers but in the end I have to because I cannot have a...

I am required to submit the minimum number of people we need to recruit for our training centre. I heard Solver can help, but I am unable to figure out where to put the constraints and how to set them up since I never used Solver and the problem I have appears to be too complex and I hope solver...

Hi! This might be more of a math question but here goes: I have two different contract rates, $52.38 and $52.50. Each rate corresponds to a certain amount of revenue, lets say $30310 and $1253 respectively. What would be the weighted average of those two rates? I got 52.39 using sum...

<tbody> Cand. No Lit Civ His Kisw Bios Math Engl Phy Chem DIV PONTS 0001 37 45 67 89 90 23 23 34 0002 24 56 78 90 34 12 17 88 45 0003 56 78 90 78 X 33 45 55 0004 23 34 45 58 78 89 87 76 0005 X X X X X X X X ABS -- 0006 56 78 90 87 65 76 54 45 23 0007 56 78 54 45 39 00...

I've inherited two spreadsheets (Yr 8 Math 2017 and Yr 9 Math 2017), both have a filter on the range MARKS!$A$4:$FK$359 The filters work fine on the Yr 8 2017 spreadsheet, whether the sheet (MARKS) is protected or not ... ie: the user can click on a filter and filter as required. The filters...

Hi there, I am trying to create a formula in which a passing grade (A, B, or C) in a second semester math class validates a failing score (D or F) from the first semester. I have grades in two separate columns and want to add an additional column that checks to see if the semester 2 grade...

With Excel's PRODUCT function, you supply a range of numerical values, and it returns the product of those values. When working with financial data, especially percentages, and you want to get a return for that date range, you have to add one to each cell in the range first before you take the...

I have some math problem written in others cell and i want its answer to appear in other cell Example: in cell A2 i have 2*3*(5+4) and i want its answer to be appeared in B2

This may be more of a math 101 question than an Excel question but I would be grateful for some help in any case. Here is a simplified example of the problem: Say you have 12 widgets to divide up amongst 3 people and each one is non divisible (has to be whole numbers). The distribution...

I have a sheet that takes several items and after it calculates, info gets pulled over into a pivot table for easy breakdown for billing. The problem is that the pivot table rounds when it receives the data, regardless of whether I want it to or not. This causes an occasional penny to be...

i want to make a diagram/graph out of a given function. The diagram (dont know the enlish term) is made out of a line connecting the X axis and the point that is calculated with the function. I have an example here in this google(r) picture. In stead of a little dot at the end of the line, it...

Hello! I was assigned to come up with certain numbers in 2 spaces (X and DX) in order to satisfy 2 different assignments and to be honest it has me quite stumped. I need to: find 2 numbers which would generate entirely negative table find 2 numbers which would generate a table with every pair...

This is a tough question to know how to ask, but I'll do my best. I feel like the answer may be easy, but I'm working off of a really tired brain. To start, I know how to calculate Weighted Averages in Excel using SUMPRODUCT. What I'm trying to determine are the upper bound of a particular...

Trying to use a userform to allow user to select ranges of data and quickly calculate the percent difference. I have been working on this for hours with no positive outcome. I can get it to work when you select one cell (not the code I pasted), but I cannot get ranges to work. If someone know...

So here's the question I haven't been able to figure out. I'm trying to build a master pin chart for locksmith purposes. One of the steps is to subtract the smallest to the next largest number. For example, if the cuts for the three keys are 545, 768, and 332. Lined up 545 768 332 The...