# if statements

1. ### If statement using "begins with"

Hello, I am trying to write a IF statement that uses the criteria "begins with". Ex: IF (Cell "A") begins with "7" then return "Hickory" otherwise return "Florence" Essentially I want to say that if the vendor number begins with the # 7 then list the city as Hickory, if not list city as...
2. ### IF Statement

Hey All, I am looking to design an IF statement that is pretty complicated. I've tried doing this with no success so far so I'm reaching out for help. Here is what I need it to say: If H2 is not Blank AND P2 Is Between 13-54 Then Category 1 Else If H2 is not Blank AND P2 Is Between 55-95 OR...
3. ### Constraints - Need help returning a value due to multiple level of constraints

HELLO, Looking for some help! I am attempting to set up an excell spread sheet to calculate my team members work loads. I am runniing into some issues. what i need to do is if a cell is given a value of an interger to return the full load value and if it is a "S" (shared value, 50% of the full...
4. ### IF statements

Hi, The company I work for is having me create an interactive excel sheet. I know that this is probably going to be using an if statement but I cant figure out how to make this work. Basically what this is supposed to do, is if you type in the number of participants in one cell, the fee will...
5. ### Help with IF MIN and MAX with #N/A

So I need to find the min and max for a column where #N/A will be present. So far i have tried =MIN(IF(A:A="",0,A:A)) =MIN(IF(NOT(ISNA(A:A)),A:A)) =MIN(IF(ISNUMBER(A:A),A:A)) My outputs keep coming back as #N/A I need to use the column not specific cell ranges because the data is being...
6. ### DAX IF Statement not working

I have a data model built in Power Pivot with a few tables connected and I am trying to do a simple formula based on a few conditions. Basically calculate this formula if Scenario 1, 2, and 3 are true. Below is a view of the Error: The way it is written is like a nested IF Statement, but I am...
7. ### Help with my if statements?

Greetings MrExcel message board! I appreciate you taking the time to read my question and thank you greatly for any insight you may have. I have inherited someone’s excel file that has been passed down from person to person over an unknown number of years. It is being used to create charts...
8. ### Excel VBA - Loop through tables + if statements

The code below works, however it is taking 8.5 seconds which in the big scheme of my whole workbook macros is ernomous. I have two input tables and one output table - Eligibility_Tbl </SPAN> and Exclusions_Tbl which determine whether </SPAN>Eligibility columns</SPAN> on the Data_Tbl </SPAN>is...
9. ### =IF(cell in a range = specific cell, return the correlating cell in another column, "N/A")

I'm trying to do a price comparison on two lists of books. Both lists have books that are in both sheets and some that are not in the other. I took both BOOKS lists from sheet 1 and 2, pasted in sheet 3, and removed the duplicates. I would really like to see if theres a way just to return...
10. L

### IF/Nested IF Statement help!

Excel & VBA Folks, I'm fairly new to VBA, but have been working hard to learn & help my company. I need help consolidating my code though, it's long & continually tests IF statements. The below code runs through about 1500 rows trying to match trade breaks to two seperate spreadsheets depending...
11. ### 13 Nested IF statements not returning "False" when relevant values should return "a"

=IF(\$I15=1, IF(OR(VLOOKUP(J\$5,\$A\$5:\$E\$68,2,FALSE)=\$J\$4,VLOOKUP(J\$5,\$A\$5:\$E\$68,3,0)=\$J\$4,VLOOKUP(J\$5,\$A\$5:\$E\$68,4,FALSE)=\$J\$4),"a",""), IF(\$I15=2,IF(AND(VLOOKUP(J\$5,\$A\$5:\$E\$68,5,FALSE)="Y",(VLOOKUP(J\$5,\$A\$5:\$E\$68,2,FALSE)=\$J\$4)),"a"...
12. ### Vlookup vs IF across several sheets

Search and count. I want to search 80 sheets for a certain number (like 93309) in \$L\$9:\$L:\$L62 and if it is true then I want it to return a "text" statement from \$B\$144:\$B\$374. Then I want to do the same thing with a SUM formula. How can this be accomplished?
13. ### VBA Code - I think too much

Whenever a dropdown is used on my spreadsheet, or whenever any information is input, the whole sheet shakes. I assume that's because it's checking all the VBA If statements. If that is the case, would it make it more seamless if all these were just one code? If so, would someone mind putting...
14. ### Multiple Logical Tests

Hello - I am trying to complete this formula. The first part works but when I add the 2nd part I just get a "#VALUE! returned. I am trying to say if cell A is <30 enter "Incomplete" if =>30 enter "Delinquent" but if cell B has a data in it (ex: a date) then ignore cell A and just enter...
15. ### Importing spreadsheet with help of if statements

Is it possible to import a spreadsheet with an if statement?. Example: I need to import a spreadsheet from a list if I select a certain category. If Cell A2 = any from the following list, Project, Open, Closed, All. I need it to import that list spreadsheet. I know i can nest if statements in...
16. ### Calculate Future Dates with Weekend and Holiday Restraints

Column A: Date that work is picked up (Example; Feb 4, 2016) Column B: The number of Business days required to complete the job (Example; 3 days) Column C: I need a formula to calculate the due Date Here are the restraints: 1. I want generate a formula that takes column A and then adds one...
17. ### else without if error

I'm not sure why I am getting this error message. I thought I had the correct indents, and I also made sure to have a new line after "then" in the if statements. Any suggestions? Here is my code Sub AddMilestone() Set s1 = ThisWorkbook.Worksheets("Release Input") Set s2 =...
18. ### IF Statement Help = (Greater Than and Less Than Statements) and Blank Cells

I have three columns as follows: Column A: Provides the number of days permitted to complete a task Column B: Provides the number of days that it actually took to complete the task Column C: This is where I need my IF Statement to calculate a simple Yes or No if the Actual Days to complete...
19. ### VBA Macro to Attach multiple PDFs and send email

I am fairly new to writing codes and built the code below using others' codes, and modified to suit my needs. I send invoices everyday (which are pdfs). Sometimes I need to send emails with multiple attachments (based on if a customer has two or more invoices that need to be sent out for the...
20. ### VLookup using 2 drop down boxes

Hi wonder if anyone can help me, I am doing a datasheet where I am looking for information from a main data sheet to report onto a front page sheet. Tab 1 is my main sheet where the info will be displayed 1st drop down box selects the tab to gather info from 2nd drop down box selects the area...

### 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...
Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
• Complex Heat Map using conditional formatting
Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
• Conditional formatting
Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...