multiple condition

1. Multiple Condition rounding functions

Hello, i got a little problem to my rounding function, i got an example Aaron = 120,200 Bella = 120,350 Charlie = 120,670 Dean = 120,880 i wanted to round to Aaron = 120,000 Bella = 120,500 Charlie = 120,500 Dean = 121,000 So far, i got into this mess, working formula, but not intended...
2. VBA VLOOKUP with multiple conditions

Hello! I have a workbook that lists products we sell, for who, when and how many we have sold of each product. I would like to add macro into workbook, which based on multiple criterias can figurate the exact matching and return the requested relevant information, what I need. To simplify my...
3. Help finding a value with two conditions, one of them being a date and the other being text

Hi, I have a question and would kindly ask for your help to figure this out. Table 1, represents the date in which each product was acquired and the price paid for it. I want to perform a search in this table so it returns the price of a product to its closest registered date. TABLE 1...
4. IIF Statement with Multiple condition

Cant figure out why i am unable to get the correct response if 3 conditions state Active then give me Active ,if they all do not give me Inactive I am building this report from Excel to Access I am trying to duplicate this code in Excel...
5. Identify unique items in a column based on a specifc condition in another column to return 1 or zero

Hello! I’m trying to find a formula for an Excel 2010 workbook that will identify the number of unique ids in one column that meet a condition in a second column then returns a count of 1 in the cell for the first instance then 0 for each recurring instance. Ultimately the count columns will be...
6. Counting the frequency of consecutive values in a column with multiple conditions

I am looking for assistance with counting the frequency that TIMEOUT appears consecutively for each driver on each day. I'm looking for instances TIMEOUT appears 3 times consecutively for a driver on a given day. At that point I'd like to know the number of rows that appear after the 3rd...
7. Vlookup with multiple conditions

Hello guys, I have a difficulty finding the right formula for my problem. I started my vlookup with many if's but didn't work. Choose function didn't work eather. I have to search for the correct owner based on multiple conditions: 1. If the ProductBrandCode is AB_N00, AB1_N00 or AB2_N00 (or...
8. Multiple Conditions for a single cell

I'm trying to use an IF statement on the following: IF(A1="Full",10) IF(A1="Half",5) IF(A1="Zero",0) IF(A1="N/A","") I want B1 to yield 10,5, 0 or blank based on what's entered into A1. I can't seem to put this altogether.
9. Vlookup - Return value finding the value between the dates

Hi, There are 2 excel data. The Data 1 excel has SKU code and has the sold amount. Data 2 excel has sku code and discount to be given during that period. So I want to search SKU and return the sku discount to be given from "Data 2" by looking the date of the data 1 between the discount period...
10. What am i doint wrong?? VBA If (X <> "A" or X<> "B") And Y="" Then

Hi, I've been banging my head against the wall trying to determine what i havewrong with my code. I have an employee roster (Sheet1) and I'm trying to get the code to look through Sheet1 and if the Last Name field is NOT "Vacant" or "Recruit" , and the Emp ID Field is not blank, then list it on...
11. IF/AND Statement with Multiple Conditions

Greetings, I could certainly use some expert help with this formula. I am trying to accomplish the following: If Cell H7 < 0, then put in "q" If Cell H7 is greater than 0 and less than 1, put in "u" If Cell H7 is greater than 1 and less than 5, put in "{" If Cell H7 is greater than 5, put in...
12. multiple conditions coming up with one solution

Alright so I have a problem.....Ive got an excel sheet that keep up with people in my gaming clan and many other things...well I have column that says if their eligable for promotions or not but theres many different conditions like Most of the conditions have to say "Yes" and one has to have a...
13. max value with multiple condition

<colgroup><col style="width:48pt" span="7" width="64"> </colgroup><tbody> S# Name Date Month Year sale 1 john 01 Feb 2012 234343 2 zeeshan 02 Feb 2012 2343 3 faizan 06 Mar 2012 9898...
14. multiple conditions for IF statement in a table, can Excel handle this kind of processing?

Hello All, I am having another problem, I have the following situation.. I want to assign a value from a Table where the specific condition is given in the table itself. the problem here is i got multiple conditions before he can assign the right value and the problem is the list is for...
15. NESTED IF formula with multiple conditions

Please help - Can I created a multiple condition NESTED if Formula using cell references? Eg: below - how would I put this into one complete formula? I don't know if I should use array, or how array works:(? 4 arguments in 1 complete formula (using cell references) IF <C41 = \$0 (or "no...
16. Sumif function

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Please clarify <o:p></o:p> When i paste the data in the columns like Process/Emp. Id./Targest. The pasted target values should automatically update in the respective process against the respective...
17. Need help counting muliple criteria in same row

I am trying to count the number of times that 2 fields of criteria are met in a worksheet. For example if you are listing each time a group of people say a particular word. You have 5 people and 5 words, but only want to count when 1 person says 1 particular word. List of names is in one column...
18. Multiple condition check and performing calculation based on each row

my excel sheet looks like this row no ColumnA ColumnB ColumnC 1 Term log 101 2 Lots 20 102 3 mode Normal 103 4 Test cats 101 5 bus 10 102 6 goo max 104 If the column C value is 101 then I need to perform Column A+B in Column D. If the column C value is 102 then I need to perform column B>20...
19. Multiple Condition Sum Problem

Hi There, I'm not sure if this is possible but I'm writing a Macro sort a lot of data and I'm at the point where I want to summarise some of the data. Basically I want to sum an amount of hours from column E based on the list of Cost Centre's in column A as in the example below: <TABLE...

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.

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