## Conditional modifiers for Date AND Time

I’m trying to create a formula that is conditional on both day and time. Specifically, if the current time is AFTER 1600 on a Friday and BEFORE …

I’m trying to create a formula that is conditional on both day and time. Specifically, if the current time is AFTER 1600 on a Friday and BEFORE …

i have column A1 to A10 and another column B1 to B10 In my Column C1 to C10 the value is from any One of A1-A10 ( that is customer enter) If C1 = …

Hi, sorry, exhausted all searches. I want a formula to tell me if the IF function result is the true or the false result. A very simple example, I have: …

Hi, I have the following formula: …

Hi, I’m working on a hydraulic analysis calculation sheet and I’ve hit a wall. I’ve calculated the average and critial velocity but theres a …

I need to retreive the value from the last non blank cell in a set of cells (not on the same row or column), so, I use this formula: …

I have two sheets in excel, firstly I am wanting to find out which names are not in sheet 1 but are included in sheet two. Sheet 1 will eventually be …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

Hi, I’m trying to search through multiple items (of which there are duplicates) to see if they have ever returned a TRUE result. The problem I’m …

I want to look up prices for styles based on which store they are in (field or house). The prices are different for both. For example, I want style 2012 price …

Hi, I have multi shifts as under; 6 to 14 = 8 7 to 14 = 7 14 to 22 =8 22 to 06 = 8 22 to 7 = 9 I am …

I am trying to see how a mailing affects the response rate of customers over the next week after it is sent. I want to do some sort of SUM IF fucntion but I …

Hi, Could anyone figure out a formula for this? If A2 contains all the text (not an exact match) from any cell from range B2 …

Hi! I have a report that I need to show the date the bill was paid on the same line. (QB wont spit out the report like this of course!) Currently, the …

I am trying to develop a formula that analyzes a specific material that has multiple inputs on a datapoint (MS). There needs to be only one identified and it …

I am using Excel 2016. I need to figure how to get the cell to calculate the total by adding specific amounts which are based on an index. For the …

I am trying to creeate a spreadsheet which will work out a certain value for myself. I am trying to figure out how I can do the following: If (such a …

How would I find an IF statement if I also need an AND statement? Ex. “If any of the numbers in cells B1, C1, D1 are equal to 5, multiply them together, …

Hi everyone, I would really appreciate if someone could help me regarding a function I am trying to execute on Excel. By:

=IF(SUM($K2+$N2+H2)-$M2<0,VLOOKUP($B2,’Container QTY’!$A$2:$B$219,2,FALSE),”0″) Hello – i am not sure how to …

How do I write the following in VBA? If (“F2”) begins with 8: true: if (“H2”) is empty …

I need to use appropriate function or functions to compare column G to B10 and return “Over budget” message whenever the results are +5% and …

I think I have the first part of this solved but can’t seem to figure our the second part with Job Status. =IF(OR([@[Pay Grade]]=”D”), …

Dear reader, The Matrix below shows the distances between different cities in Poland. I have a dataset with courier services where the recipient city and …

Hi there, I’m trying to put in a function that will return a value from a range of cells when I put a related value in another cell. In column A I have a …

Hello! I am working with Excel 2016 on a PC. I am trying to list client information from sheet 1 (Proposal Tracking) onto sheet 3 (Client List). I have the …

I currently have this formula =sumproduct(––isnumber(match(Closers!A:A,‘Consent to Contract’!E:E,0))) This is counting all matching …

Dear Excelgeek, I need your help to make formula for my study, here is the result table: Male Result Age Very Good Good Fair Poor Very Poor 10 …

Hi, I am just wondering why my IF function is not working correctly. Any help is appreciated. By:

Hello, I need help with a formula. There are 4 cells, only one will show a result at a time, I need a formula that will check the 4 cells and return as …

Hi below is a basic spreadsheet for what i require. In the RATE cells i need the following input. I want a search to be done in the REd category column. …

Hi All, thanks so much for taking the time to read this, hopefully I am clear in what I am asking and doing everything correct according to the forum …

<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–> up front/ annually quarterly/monthly $1,000 $4,999 5% …

Hello – I am wondering if it is possible to create an IF/VLOOKUP (or something similar) statement that does the following: There could be 2 rows …

Im having a little trouble with a code in excel vba. My goal is convert the following if statement to a VBA macro. The if Statement: IF(R8=“W”, …

Dear group below is a table that i’m trying to create a table for. its looking at dependancy ratio’s and giving a weighted score, but i have the …

I’ll outline the situation: I’m assigning different prices for energy being consumed within different time periods within a day. 23:00-7:59 is x, …

I need help writing an If/Then statement in Excel. I need to do ranges and the output differs based on the range. For example, if the answer of a …

I am working with data from a relational database exported to excel. A 6 digit code in one cell will drive what codes go into the other cells. The third, …

How would I go about copying a unique value from one sheet to another. For example, I have a unique value in Cell B in Worksheet 1, I’d like to return a …