multiple if conditions

I have a proposed billing date (A1) and a status (B1) and (C1) actual send date. My formula for B1 is: =IF(AND(A1>=TODAY(),"Pending"),IF(AND(C1<>A1),"completed")). To be sure it is "volatile". The concept is to alert the user to the upcoming send date, A1, hence "pending", but once it is sent...

Hello All - Thanks so much for any ideas you might have on this: I am trying to combine the following statements, each of which seem to work fine on its own, into one statement. Have googled, have searched here - surely I am missing something fundamental. Many thanks for suggestions...

Hello I need to calculate the average value of a column contain temperature values (column H). The difficult part is that I want to average only specific cells of this column, that meet certain criteria. More specifically, I want to average temperature values from column H, only if the wind...

Is it possible to do one formula for the following true/false (yes/no?) check: If column K has a "V", but none of the other criteria, then check array #1 for a true/false if the number in column D is in it. If column K has an "H", but none of the other criteria, check array number #2 for a...

Even with all the help I've received on this forum, this code is practically finished, but I'm getting the "LOOP WITHOUT DO" error. And I know what that means, I just don't know where in the code the error is being triggered. There are literally no articles I can find commenting on this many...

Hello, I am a student and new to use VBA. My query is; I have an excel sheet containing voucher details, I am planning to bring a summary sheet and able to pick one variable data from the "voucher" sheet to summary sheet. I made it like productname1 as the first variable, that is in "A3"...

Hello fellas, I have over 60000 rows of data in excel 2010. Each row have unique client name like I have 4 client names I want to keep the same as their real name in Client placeholder to automate column. I have another 40 clients like John and David that I want to assign them Other in Client...

I have searched for this question but have not found an answer that works for my scenario. I have range J2:S2 that have flags (I'm just using the letter "x"). I need my formula to tell me if the range contains multiple x's (Multi), a single x (Single) or blank (blank). I was able to...

Hi everyone! I have a quick question -- I wanted to learn to write and IF statement that would search for certain words. If it's not there then say this, if it does have one of the said words then write this. How would I do that? Here is an example of what I need to do: Column, Row A, 1...

Hello! I have almost finished my spreadsheet project that I was working on, yesterday. I've hit one final snag, though. I need to auto-populate a couple of dates that result from calculations and multiple IF statements, and I would VERY much like to combine all of these conditions into one...

=IF(G3<>"",F3+G3,IF(H3<>"",F3+H3,"0")) <tbody> </tbody> Hello, I am trying to set up a formula that depending on where information is plugged in will add certain cells. Otherwise if they are blank leave it at "0". Also trying to add in if BOTH have numbers add certain cells (F3+G3)...

Hello all, I am wokrking a 100k line spreadsheet and need some help. I am trying to display the value in column D from sheet 1 of my file to sheet 2. The catch is I need columns A, B and C to meet certain critera. Col. A Col. B Col. C Col.D Blue Circle Table 1000 Green Square Chair 2000...

Hi, I have created a multiple IF statement to display a certain value based on the text of a list box cell. The formula is working correctly and I have pasted it into 6 other cells. The problem occurs when I try to calculate the SUM of the 7 cells. I have entered a simple SUM statement for the...

Hello, I am trying to use this formula: =IF(AND(C753>=10/01/2012,C753<=12/31/2012),"Qtr 1",AND(C753>=01/01/2013,C753<=3/31/2013),"Qtr 2",AND(C753>=04/01/2013,C753<=06/30/2013),"Qtr 3",AND(C753>=07/01/2013,C753<=09/30/2013),"Qtr 4","N/A") I know that the "AND"s are screwing everything up, but...

I have a list of cases which includes the date they were opened and the date they were closed. I need for formula which will check which cases remained open at the end of the year. I am working across several years, starting from April 2007. For example, if a case was opened in 12/06/2007...

I'm using Excel 2010. I'm working on sales commissions & bonuses. The commission part is easy – just multiply the cell w/ the sales number times the commission rate (as an absolute reference). I'm stuck on our sliding scale for bonuses. For example: IF sales >=120,000, bonus =2.5% IF sales...

Hi, I am working on a report and need some assistance. I am working with Windows XP Professional and Excel 2007. My report is looking for a formula that will reflect if the goal is in jeopardy of being missed. If cell A2 = "COMP" the result should be "NO" If cell A2 = "PENDING" and cell B2 is...

I have a spredsheet were I need to to do two tests, and bring back one of three results. Consider this: <TABLE style="WIDTH: 359pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=478 border=0><COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 71pt; mso-width-source...