if(and formula

Hi This is my excel file I am trying to put a band automatically in column W but it is not happening What I need is that if an Employee salary is >= 15000 but less than 20000 then he/she be in Band "I" similarly in increments of 5000 till band "XV" However the above formula is sending an...

I feel like I'm missing the obvious here. On this tab below, column A lists kit names (KITNAME) and column B lists its associated kit category (KITCAT): On the following tab, I want the cells in BD41-BJ45 to return a value of -1 if the entry in column B is listed in KITNAME above and the...

I have a program that I am require to use that outputs data horribly and makes it very hard to see the big picture for where everyone is for their certifications. I output everything into a CSV (only way I can) (Qualifications). I am trying to get the data to look more presentable so I can see...

Hi, I have my accounts in excel from 200000 to 499999 and i want to do an IF(AND function for cell A1 where i differentiate the output in Raw materials and services and so on. The first step i can make work: =IF(AND(A1>200000,A1<300000);"Raw materials";"") This part works. But i want to do...

I am attempting to combine the below formulas into one cell in an effort to return 1 of 4 option based upon my data and criteria in cell F2: =IF(AND(E2>=TIMEVALUE("6:00:00 AM"),E2<=TIMEVALUE("11:59:00 AM")),"MORNING") =IF(AND(E2>=TIMEVALUE("12:00:00 PM"),E2<=TIMEVALUE("6:00:00...

I created a auto-calculate spreadsheet to display Employer contribution % for both employees and dependents (enter % in specific cell). To account for the many combinations of 0%-100%, I have tried to encompass the following combinations in a nested IF(AND statement. I am looking to put...

I am attempting to deliver a pricing model (matrix). The model is dependent on the number of average transactions (x-axis) and the number of overall customer. As pricing increases, the incremental cost decreases (i.e. the incremental cost at 5,000 is less than that at 1,000). I have created...

Hello Forum, I'm struggling with a nested formula that uses several IF statements and two IF(AND) statements. The formula is shown below. The error message I receive is "The specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file...

Hello there I am very new to this forum, but already have found a lot of great help. Thanks! However, I have a new problem. I am using the "=if(and(" function, but Excel is rejecting more than 7 functions. I will need at least 20. Is there a way around this? The data I am working on is as...

Hi: Excel 2011 for Mac not happy with the following formula ;√( =IF(AND(CC3>=-.85*CD3-CE3,CF3>=CD3-.85*CD3-CE3,1,0)) This is a simple test looking to count long tails at the close of the day for a stock. CC3 = OPEN CD3 = HIGH CE3 = LOW CF3 = CLOSE Any suggestions? Thanks, Michael

I am attempting to create an IF or IF(AND formula that I can use to display the letter grade I earned based off of a certain percentage criteria. I have had trouble creating this formula myself. Hopefully someone can help. Please refer to my notes below to examine the criteria. Let me know if...