# mathematics

1. ### Confidence Interval Trendline

Hi All. New to the forum, so please be gentle. I have a bubble chart that I have a weighted trendline on. I'm not happy with how the line of best fit gives a misleading representation of the predictability of the data, hence I would like to replace this single line with a band of possible...
2. ### How can I justify my eagerness to learn mathematics to office people?

Hi, Our office has a budget for trainings. But on one condition: It should improve/helpful/ or atleast useful to the current works we do on our team (VBA Development using Access/Excel). I know without the word 'Mathematics' there is no such word called 'Engineering' (all sort of). The problem...
3. ### Time Conversion/Fractions of a Second

Hi guys and gals I got a possible tough question for ya. I'm doing calculations with lap time and race cars and need the fractions of a second. I got my time to work out with a m.ss.000 format. (need the fractions of a second) But I'm doing calculations in formulas that require ^2 and things...
4. ### Autofill Mathematics Algorithm??

Hi all I am trying to find out whether it is capable in MS Excel to write an algorithm or some sort of VBA code whereby excel will fill in the "blanks" of a formula to give pre-determined results. Let me try to explain myself more clearly. Say for example I had 2 equations. Equation #1: (a +...
5. ### Mathematical problem-ROUND function doesn't help

I have an annual sales target of no. of units to be sold which is to be divided quarterly. My historical sales data gives me the ratios in which the annual target is to be divided into quarters, the ratios are 0.17, 0.23, 0.3 and 0.3 respectively for Q1,Q2,Q3 and Q4. When I divide the target...
6. ### Complicated(?) Cross Sum function

Hi All, Does anyone know a formula for the following problem (I have up to 120 iterations to do and the thought of typing them all out makes me want to quit) I have a response curve and a number of volumes and want to sum up the value of the responses e.g.: <TABLE style="WIDTH: 333pt...
7. ### Need HELP........

I am working on a project that involves trackable keypunching for a designated time frame. I need a formula that will give me the average time spent on a certain task. Here's what I have: 1. Number of "batches" completed 2. Number of pages within a single batch 3. Time spent on each batch...
8. ### Excel trivia or math challenge?

In Excel 2007 there are XFD # of columns. My 7th grade computer apps class and I are trying to figure out how many that is? We think if it was ZZZ it would be 27 to the 3rd power, is that even right. Or would AZZ be 27 to the 3rd power? If you know and wouldn't mind explaining the math to us...
9. ### Help with formula to extrapolate population characteristics to different demographic set

Here is my basic flow: State Population State Electorate County Population County Electorate M 45% 42% 40% ? F 55% 58% 60% ? Here is the question I am trying to...
10. ### Complex Erlang maths and formulae.

Hi there, I am doing mathematics that is just extending me a bit too far. I have an excel spreadsheet that is trying to calculate the hold times for a helpdesk. This is the spreadsheet to download http://www.jaybest.com/tempo/Tempo_RosterTool-BetaV1.02(Exposed).xlsx This is the formulae that...

### This Week's Hot Topics

• SUMPRODUCT active link formula
Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
• Block certain cells in condition met in cell A
Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
• IF FUNCTION FIRST, THEN WITH INDEX AND MATCH
Hi, Below formula works well, =(INDEX('PRICE LIST'!\$C\$7368:\$C\$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!\$A\$7368:\$A\$7679)*(WORKSHEET!P28='PRICE...
• Match data from 3 columns to return data from the correct 4th column
Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
• VLookup
Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
• Defining a range
Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox... ### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?    ### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option. Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com". Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button. Go back