# calculating

1. ### Date Difference

I am sure this can be done, but I am not able to find anything specifically addressing it. Is there a way to create a DateDiff parameter in a query, where is it calculating the days, between current date and a date field within the table the query is built from?
2. ### Combine Nested Funtions

Need help combing these function into a single cell This formula recalculates the date based off a value in column P =IF(OR(P16="A - Svcbl(w/o Qual)",P16=""),(AM16+450),(AM16+90)) This formula determines the amount of days between today and the new date =ABS(AN16-TODAY()) This formula enters...
3. ### Calculating the Probability of a Type II Error

I am having trouble calculating the probability of a Type II error using Excel. Here are the hypotheses tests I need help with: 1) z-tests (left-tailed, two-tailed, and right-tailed) 2) t-tests (left-tailed, two-tailed, and right-tailed) 3) F-tests (Equality of Variance tests and One-Way ANOVA)...
4. ### Formulas not calculating correctly

Help! I have spreadsheet in excel, and a few of the cells are not calculating correctly. My worksheet has 4,000+ rows, and one column has the following formula: =IF(AL4051="D",IF(+T4051=1,COUNTIFS(AL\$2:AL4051,"D",U\$2:U4051,"<3",A\$2:A4051,A4051,T\$2:T4051,1),0),0) The formula calculated...
5. ### Calculating difference in time - conditional formatting

Hi all I would like to calculate Time-in - Time-out and if there is less than a 9 hour difference, highlight the cells. In the example below B4:B5 & C2:C3 would be highlighted. <tbody> Time-in Time-out Time-in Time-out Time-in Time-out 08:00 18:00 09:00 22:00 06:00 17:00 12:00 23:00 07:00...
6. ### VBA Function Background Operation

I wrote custom VBA functions in Excel that stop continuously calculating when I activate a different workbook. They are populated with RTD streaming from ThinkorSwim and generate audible alerts when certain conditions are met. They work great until I open/activate another workbook and then...
7. ### IF/And OR vs calculating DOB less than 18 years of Age

=IF(AL2="",AND(OR(S2="IN",S2="KY",S2="HI",S2="WV")*TODAY()-N2/365)) Above is the formula I wrote to calculate less than 18 years for particular states. This is what I a trying to achieve and not sure how to go about it. Column AL has ID Column S has States Column N has DOB Column AE has...
8. ### Calculating mumber of incidents per month

Hi , In Column B I have dates of incidents . How do I calculate how many incidents were in each month? I tried this =COUNTIF((B2:B1000),"<31/01/2019") Which obviously calculates a range but is there a formula I can use that would just calculate each months incidents?
9. ### calculating day intervals, omitting 1 given day

I'm looking to calculate the days of the week between 2 sets up days, while not factoring in Saturdays. For example below (with service days being the result): <colgroup><col span="2"><col></colgroup><tbody> A B Service Days 30-May 3-Jun 3 </tbody>
10. ### Formula NOT Calculating for some odd reason

=LOOKUP(2,1/(U:U<>""),U:U) I'm using the above formula and it works fine on my computer. I sent the schedule to some other people and it's working fine for most; however, for one individual, the cell with this formula isn't calculating: Her Options are set to Automatic Formulas: all other...
11. ### Calculating a date

Hi I have a spread sheet which shows employees (trainees etc) who are under 18. In cell B2 I have thier DOB. Then in C2 I want a formula that returns the date of when they would reach 18. Anyone know how to do that?
12. ### What is going on here?

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody> 2012 \$13,641 4% 2013 \$13,057 -4% 2014 \$15,233 17% 2015 (\$6,145) -140% 2016 \$6,845 -211% 2017 (\$8,920) -230% 2018 (\$22,802) 156% </tbody> I am using...
13. ### Convert Text String to Single Letter Range/Single Number Range?

Consider the following two formulas for calculating the last row in a column and last column in a row: Formula for calculating last row in a column: =LOOKUP((2), ((1)/((E:E)<>("") ) ), (ROW(E:E) ) ) Formula for calculating last column in a row: =LOOKUP((2), ((1)/((5:5)<>("") ) ), (COLUMN(5:5)...
14. ### Calculating stdev.s excluding a certain value

Hi, I'm trying to calculate the stdev.s of a dataset that isn't 26. This is the formula I'm using - {=STDEV.S(IF(Sheet1!V:V<>"26",Sheet1!V:V))} and it gives me 8.3 If i calculate the same data set but remove all the 26's using find and replace, i get 18.9 What am I doing wrong?
15. ### Calculating speed issue

Dear All, I have create array formula to capture sum up individual record which is meet the criteria as : =SUM(IF(FREQUENCY(IF((Risky_Type_F="High...
16. ### Calculating specific columns

I am attempting to calculate if column H has a specific name in it ex. John Smith and then sum column O which has numbers in it. Not sure the best way to accomplish this or what formula to use. Any help would be appreciated!
17. ### calculating vaction accrual by hire date

i need some help fixing a spreadsheet to helps to calculate vacation accrual
18. ### Calculating Hours Worked

I need help with determining a formula that would count total hours base on not looking at the “>=” in cells B3 and B4, and not looking at “<=” in cells C3 and C4. Please see the following image for the outcome I am trying to achieve in cells D3 and D4 Thanks for the assistance.
19. ### Worksheets not calculating

I'm using Excel 2010 and trying to one-button automate updating a spreadsheet. The button should refresh two tables from outside (networked) workbooks and then calculate worksheets in the open workbook, in a specified order. Here is my macro the button is linked to:Sub Workbook_UpdateAll()...
20. ### Calculating total sums based on other cells

I thought I had this figured out, but it's doing my head in now! I'm trying to calculate the total value of WINS only. Can anyone help? Thank you.

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

### Which adblocker are you using?

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

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