if statements

Could someone explain what is wrong with this formula.... =IF(AND(C247<2,E257>0,IF(C247<3,E262>0)),"Please ensure all irrelevant options are blank","") The first part works [BOLD] but the second part doesn't. I'm not sure exactly why they cant work in conjuction? Thanks

Hi, I have searched far and wide for a solution to this and spent hours trying to figure it out, and I am now admiting defeat and hoping someone will be able to help me. I have the following type of data: Example dataset: <tbody> A B C D E 1 Level Time Bin Range Level Frequency Level...

I am running a contest at work and I need a cell to return different values IF based on the returns results. For example the column header is "Current Reward" and I want it to return either "$500", "$750" or "$1,000" depending on the the data at specific value benchmanrks. I know I am doing...

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

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

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

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

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

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

=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"...

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

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 Sub AddMilestone() Set s1 = ThisWorkbook.Worksheets("Release Input") Set s2 =...