If cell contains part of a differnt cell range then enter the number

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 …

Special Lookup

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 …

Using If/And/Or Statements to deliver one unique value

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 …

Which is the best function

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 …

Creating an excel formulae with multiple options

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 …

If/AND with multiple cells

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, …

Architect

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

Excel IF and vlookup combination help

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

IF cell contains text with nest

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

Formulae help

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 …

If/Or Function Help

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”), …

Matrix and kilometers

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 …

Excel Function to insert a value from a range of cells if the same value is entered in a named cell

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 …

IF Function Help

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 …

Sumproduct with extra Criteria

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

complicated if function

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 …

IF Function

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

Check multiple cells to show the one with a result

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 …

IF Function-IF criteria is met i need a lookup and calculation

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

I think I Need an ANDIF / Match formula, but not sure

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 …

Vlookup or if

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

If/Vlookup Help?

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 …

Excel VBA Question: If, elseIf, esle Statement

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”, …

IF and OR – using OR to provide a rule avoiding #DIV/0

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 …

if and and time

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, …

Need Help with If/Then Formula

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 …

Excel Formula Assistance

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 to copy data from 1 worksheet to another if cell contains matching text (not exact match)

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 …

Multiple Conditions in an IF Statement

Hello.  I am trying to write an “IF” statement that has multiple parts and coming up short. The 2 conditions are:   if cell K13 is blank …

Complicated nested IF AND OR statement….

Ok here goes…. So I am trying to evaluate two sets of values in two cells let’s just say, for the sake of argument, cell A1 and cell B1.   …

STDEV will not consider IF statement

Hi – I’m trying to take the STDEV of averages for a given week. I know there is no STDEVIFS like there are for AVERAGEIFS so I found other ways …

Using a set of numbers to display a second, different set

Hi! I am having problems figuring out an Excel formula. This is for Excel 2010 on a Windows PC.  I want to enter a number in one cell, then display a …

Which formula should I use?

I’m working with about 4,000 names and zip codes of local volunteers on our registry. I need to sort them into specific jurisdictions based on their zip …

VLOOKUP & IF OR MATCH/INDEX

Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be …

Excel If and AND Functions

Hello,   Please could you help. i need a formula for IF Column B had data in and Column J is Empty then do this …

NEED HELP IF/THEN FUNCTION

I am trying to create an if/then function with text…every way i write it i get error..I want to make it so if 2 cells that are adjacent both contain …

Help with ISERROR

Hi   I am trying to add the ISERROR to the below formula.  I am calculating between dates to return a value or sum the amount of months in between …

excel

BANK TRANSFER POS 1.5% CASH FORM OF PAYMENT 0.00 0.00 0.00 TEXT IF THERE IS A VALUE OF MORE THAN 0.01 ONLY IN BANK TRANSFER BUT ZERO IN POS OR CASH THAN FORM …