# ifs

1. ### Using a named range in an IFS formula's criteria

Hi, I have an IFS formula thus: =COUNTIFS(Orders!\$V:\$V,\$K\$4,Orders!\$H:\$H,I7,Orders!\$G:\$G,"unfulfilled",Orders!\$E:\$E,"<43566") where 43566 is the serial number of a cut-off date. This date is however regularly changing. I have created a named range, Order_Cuttoff_Date and put the date in...
2. ### Wildcard in IF statement

Hey there, I know you cant really put a wildcard in a if statement but does anyone have any suggestions to get this formula to work? =IFERROR(INDEX(Number; MATCH(0; COUNTIF(F\$14:\$F14;Number)+IF(Priority<>\$C\$3; 1; 0)+IF(SelectedCustomer<>Customer; 1; 0); 0)); "") I want the selectedcustomer to...
3. ### Multiple Ifs in Subtotal function

I am trying to determine if there is a way to add multiple “IF”like functions to the troublesome issue of countif/averageif during a subtotal. For Instance, I retrieve my data from an internal server atwork that gives me a spreadsheet with times listed in column B, the type of...
4. ### Cell value to trigger list of selections

Afternoon, I am very sorry, this is a from scratch question as i'm not even sure if it's doable! i am doing a spreadsheet based on UN transport numbers, the best example to get across what i am trying to do is 1950 <tbody> 1950 WASTE AEROSOLS, asphyxiant 2.2 1950 WASTE AEROSOLS...
5. ### does IFS() calculate the redundant terms in background

to save wasted processing I sometimes use =if(A1="","", [heavy formula]) which clearly works, as the heavy formula isn't calculated when its redundant. But if i use IFS() to do the same (as per the below) =IFS(A1="", "", A1=0, "", 1=1, [heavy formula]) it should do the same... BUT when...
6. ### Have too many ifs for one formula

Have too many ifs in my formula. If I trying using IFS the formula doesn't work. Tried usings IFS, and several other combinations but to no avail. Maybe I'm trying to do too much for cell...
7. ### Lookup on specific text in a cell to return value in another cell

Hi, I have an issue whereby I download data each month and the text in these cells changes slightly each time so it’s not possible to use a standard vlookup. What I would like to do is lookup specific text in one cell to return a value in another. For example the following is in these cells...
8. ### Nested IFS/Multiple Formulas

Hello, I am seeking help on the following problem: <tbody> a b c d f g h i j k l m n o p q 1 Upgrade 1 Upgrade 2 Upgrade 3 # employees Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2 Jan Feb Mar 3 </tbody> I need to write a formula for cells F2:Q2 that calculate the...
9. ### Formula for validation data

Hello , i need put in validation data a formula or vba a code for check the next : In sheet “Codes” put the code for example in column C “asdf” and in the column J put 2. In the second sheet “Pool” put the next below: <tbody> Codes Number Asdf 100 </tbody> I need check for the same...
10. ### Calculate Increase/Decrease

Hi, I’m stuck. I need to calculate whether waist circumference has increased, decreased or remained stable (while ignoring if any cell is blank) I can’t get the IFs formula to work. I got it to do the increase and decrease, but can’t get the stable. When I tried to modify the formula to be IFs...
11. ### Help with calculations using ifs and minimum

I need help creating an ifs formula that will calculate based on a minimum number. Here is an example: <tbody> TABLE 1 Widget --Widget Length-- --Widget SF-- \$\$\$PRICE\$\$\$ </tbody> <tbody> TABLE 2 --Widget Length-- --Widget Cost-- 0-24' 5 25'-28' 10 29'-32' 15...
12. ### Average of cells that meet two criteria

Hi everyone. i have a sharepoint list that contains observations my training team have made for numerous colleagues in the department. The can be observed on various different tasks and they could have been observed more than once. I ask my team to rate the colleague from 1 to 4 on that task...
13. ### IFS Statement

Hello. I have an Excel worksheet with about 1,000 cells . The cells have number values between 0 and 20,000. I want to replace the numeric values with the words below. <5000 = Sedentary 4999>, <7500 = Physically Inactive 7499>, <10000 = Moderately Active 10000>, <12500 = Physically Active...
14. ### Indirect if?

Is there way to setup a INDIRECT (A Custom Drop Down List) if multiple IFs are used? If so, can someone please help me?
15. ### Lookup header based on name

Hello, Please help me find a formula for this problem I couldn't think straight. I need to get the header title/the levels using the names. I hope you guys could help me thanks. Please see image below.
16. ### Look up on multiple criteria

Hello community, I have kind of a noob question here. <tbody> City District Information City (X) District (Y) Urban(1)/Rural (2) 1 2 1 1 1 1 1 1 2 2 1 2 1 3 1 2 3 2 1 1 2 2 2 2 1 1 3 2 3 2...
17. ### Formula Query: IF, CONCATENATE or INDEX MATCH?

Hi, I'm trying to calculate a formula to help me with tracking some football scores. Please see the attached sample. I have a sheet that tracks the team members and every gameweek across the season, in particular the goalscorers. For example if you look in Column E, three goals were scored by...
18. ### CountIfs how to

My Data <colgroup><col><col><col><col><col></colgroup><tbody> 1 A B C D 2 Sequence Date/Time Who What 3 1 10/1/18 2:41 PM John Smith Open* 4 1 10/1/18 2:41 PM John Smith Edited 5 2 10/4/18 2:15 PM John Smith Open* 6 2 10/4/18 2:15 PM John Smith Edited 7 3 10/5/18 2:16 PM John...
19. ### Ruturn values from Table from time range

I need to return Start and Start2 separately, when a time supplied is between length and length2. Currently 5 IFs but need to extend to 13 periods <tbody> #ffffff[/URL] "]length #ffffff[/URL] "]length2 #ffffff[/URL] "]Start #ffffff[/URL] "]Start2 #ffffff[/URL] "]test #ffffff[/URL] ...
20. ### If with 3 conditions and 3 possible answers

Hi, guys First, excuse me for my english. I hope you guys understand what I mean. I have the following data and conditions: A1 = 7 B1 = 2 C1 = 9 (the answer would be 7) A1 = 0 B1 = 5 C1 = 3 (the answer would be 5) A1 = 0 B1 = 0 C1 = 4 (the answer would be 4) A1 = 0 B1 = 0 C1 = 0 (the answer...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...