# logic formulas

1. ### Date formula needed

Hi All, I'm struggling with a formula. I have 2 date fields: Cell D1 - 10/1/19 Cell E1 - 11/1/19 On another tab in the workbook (Summary) I have Months listed in column A; January February March etc. through December I'd like to be able to allocate a "1" to the Summary tab, Column B...
2. ### SUMIF with double conditional

Hey everybody, I've been racking my brain around this for a few hours now and just cant seem to come up with the answer, was hoping someone here may have a better idea than me. Essentially, I have a database where I need to SUM a range IF the criteria in two cells of two columns are met...
3. ### Multi Condition Logic Formula

Hi folks, I need some help with a formula. Column F, rows 6 to 1000 contain drop-down lists with the following codes and range: Drop-down selections: H2019 is in cell N6 H2020 is in cell N7 H2021 is in cell N8 Minute's location: 15 is in cell O6 30 is in cell O7 30 is in cell O8 In column...
4. ### Adding IF and COUNTIF together?

Here is my worksheet example. I need a formula to count how many times the 'Service Level %' was greater than 79.999% for each day of the week. So for Monday, there is two data points, but, 1 would be my answer in this example. <tbody> Weekday Service Level % Calls Offered Work days Mon 81%...
5. ### IF / And / Or statement combined

Hi, I have 2 columns of dates E and J. At E there is always a date, at J there can be a date or it can also be blank. I want to say that if a date is <= at any date in E and if a date is <= J or blank, then show as Active, if not Inactive I came up with this statement =IF(and(E2 <=...
6. ### Dynamic IF formulas

Hi all, I'm fairly new to excel, so I hope you can help me. I have a large dataset with monthly tracking data. In one of the sheets i perform a lot of "conditional checks" (typically IF formulas). The problem is, that when new variables are added to the data set, the IF formulas refer to the...
7. ### [Calculated Fields] how to Get Count Product more last month

i want to used [Calculated Fields] on Pivot table to show customer buy number of product compare last month Ex Month 1 Customer 1 Buy 4 Product A B C D Customer 2 Buy 3 Product A B C Customer 3 Buy 3 Product A B D Month 2 Customer 1 Buy 4 Product A B C E Customer 2 Buy 3 Product A B D...
8. ### populating a full list of all like (tyres)

I am trying to create a spreadsheet the will populate/pull all tyre sizes that I have collected from different suppliers. <colgroup><col><col><col><col><col></colgroup><tbody> Tyre Size 165/80 R13 Size Brand Cost Price Selling Price Supplier </tbody> Cannt...
9. ### Need help with a formula modifier

I have a section in this spread sheet that is working really well but now I need to modify it to fit a new requirerment. The first cell returns the number of personnel The second cell returns the number of expired certificates The third cell returns the total number of valid certificates The...
10. ### SumProduct Excel 2010

Hi, I have a complex sum problem. Excel located here: https://dl.dropboxusercontent.com/u/52990313/sum%20product.xlsx Column A is the # of months Row 1 are monthly dates starting in B1 from 9/30/12 on... from B2:BA9 are the numbers to sum Here is the goal of the formula: 1) Has to start adding...
11. ### Function help, (logic?) assigning a value to a cell based on another

Hello, I am trying to fill in the Net height in the below table based on the Net assignment located next to species. If Net=A then Net height should = 2.6 for MYLU but should be 10.4 for MYSO. I've tried a nested IF function =IF(B1="A",C1 IF(B1="B", D1)) but it returns an error. I could do it by...
12. ### Countif (display) first instance of a number only

I am creating a financial model where I am trying to calculate the NPV and rNPV of several assets. One of the potential streams of revenue is a one-time 'milestone' payment of \$30M if/when the cumulative sales of the product exceeds \$500M. I have projected revenues from product sales for years...
13. ### If/then statements in multiple cells

I'm trying to figure out how to write a formula for the following: I have data in cells d12, d13 and d14. If the number in each of those cells is 6.5 or higher then I need the words "Meets Criteria" to appear in cell d11; if the number is lower than 6.5 in any of those cells then the words...

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...