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...
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...
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...
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...
So I need to find the min and max for a column where #N/A will be present. So far i have tried
My outputs keep coming back as #N/A
I need to use the column not specific cell ranges because the data is being...
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...
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...
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...
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...
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...
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?
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...
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...
Is it possible to import a spreadsheet with an if statement?.
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...
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...
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
Set s1 = ThisWorkbook.Worksheets("Release Input")
Set s2 =...
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...
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...
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...