logic formulas

How to match Same number via join data NOTE: Not use this formula ( =+C3&" "&D3&" / "&C5&" "&D5&" / "&C6&" "&D6) WE NEED THIS PERFECT FORMULA IN THIS QUERY

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

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

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

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

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

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

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

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

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

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

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

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

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