multiple conditions

Hi All - I have a nested IF statement that only partially works. <colgroup><col width="114"></colgroup><tbody> IF('20160229 ESD POS Import'!L3="B&H Foto and Electronics","005D0000003916X", IF('20160229 ESD POS Import'!L3='Special Accounts'!A:A,AY3,IF(L3<>'Special Accounts'!A:A,AV3)))...

I want cells data in column B to color green if colum A fulfills some of these conditions (in table below). For example if SIZE is greater than 4B in cell A1 and GROWTH is greater than 5% in cell B1 then cell B1 to be in green or if A1 is between 0.4B and 4B and cell B1 is 7% or more then cell...

Hi, I'm trying to figure out how to test multiple conditions with IF OR. I have a table like the one below where 7 conditions are checked. Now I want to create a formula that checks all of the 7 conditions and returns TRUE if any of the 7 conditions are TRUE. If all 7 conditions are FALSE...

The old thread here on Mr. Excel does mostly what I want to do: hide rows WITHOUT Macros in Excel. However, I want to do something a little more expansive. I know nothing about VBA, so I need a little help, as I tried to add multiple criteria to the code above and it didn't work. I have a...

Hello,</SPAN> I have a two part question I’m hoping someone can help with. My brain is so fried at this point, I can't think straight about this anymore! :eeek:</SPAN> How do I update the formulas in the Total column (B) to only count one instance of a “Name” on the data (“raw”) tab (also...

So I've got this far: {=IFERROR(INDEX($B$9:$B$496,SMALL(IF($C$9:$C$496>G$507, +IF($C$9:$C$496<g$508,row($b$9:$b$496)-row($b$9)+1)),rows($b$9:$b9))),"")} We are dealing with a list of Standing Order payments from customers. Each has a different day of the month. I need a way of finding which...

I am hoping someone can help with my formula problems.</SPAN> I can easily edit a formula to apply to all of the needed items/calculations (a few listed below). I am just including more than one because when I thought I had found the correct formula because it returned 0 when 0 was correct, I...

Hi, I am trying to find INVOICE ID for all Invoices shipped for each SKU after a certain cut off date. I have a list of over 1000 SKUs with multiple cut off dates for each SKU in Sheet1. The invoice shipments data along with the dates is in Sheet2. I have tried to create a Pivot table and used...

Hi, I'm running analysis of data that includes delivery times for two distinct store types (stores under 3000 and over 3000). Each delivery is distinguished by "Run" which can repeat for different regions (see example below). What I need to find is relative position of stores that are over 3000...

Hello! I am trying to highlight the row in green that if column e is greater than 500 and column f is greater than 5. also highlight in yellow if column e is less than -500 and column f is less than -5. Also if there is a zero in both of the cells I do not want it to highlight at all. (C)...

I have a large dataset and I need to count the number of unique entries in one column, if it belongs to one group or another (it is indicated in another column, e.g. it may give group ID of 23 or 34 or 193 etc). Ideally, it would be a formula which I can use across many entries (need to do this...

Hi, I'm a bit stumped, any assistance would be appreciated. I'm trying to return the values "Hard", "Instructional" or "Independent" dependent upon a number of conditions from a student's reading test. The formula needs to first determine whether they completed a task from A to K (alpha...

I need to count the number of unique offices by summary position=Associate, fiscal year=2014, offer acceptance date>0 and school=I1 (which is a drop down box for all the schools we recruit from). Please help! I've been scouring the web for hours. My ranges are named, I am able to come up with a...

More information I am trying to have a cell return a value based on multiple conditions. From the table below: <tbody> A B C D 1 Project Origin Destination miles 2 Alpha washington california 1500 3 Alpha michigan california 1000 4 Alpha atlanta ohio 750 5 Alpha chicago ohio 356...

Hi Guys... Please help, I'm trying to use the =AND formula to conditional format values in E column based on multiple conditons. e.g If E1 is equal to (Condition 1 is E1>= B1 )and (condition 2 is E1< C1) colour cell red. <C1) green. So the formula I'm trying and excel is rejecting is...

My table may have either This or That in column B. Column B This thing That thing Ain't no thang And another thing Are you going to eat that This I no big deal That is a lie I need a formula in Column C which will return "Eureka" if either "this" or "that" is in column b. For some reason my...

Greetings, I could certainly use some expert help with this formula. I am trying to accomplish the following: If Cell H7 < 0, then put in "q" If Cell H7 is greater than 0 and less than 1, put in "u" If Cell H7 is greater than 1 and less than 5, put in "{" If Cell H7 is greater than 5, put in...

I am new to the forums and am teaching myself VBA. I am trying to paste cells from an input tab, send them to the appropriate tab which is the variable, Tabref. When the macro finds the correct tab, it will then match criteria in 3 separate columns, which are Abbrev, Merchant ID, and Amount...

I am looking for the best way to use conditional formatting in a Gantt chart. I want the cells to turn blue if they fall between two dates. Any help would be greatly appreciated!

Can anyone assist? I am trying to combine multiple conditions in a formula, it needs to be a formula and not in access. I have a spreadsheet which simplistically contains three columns of data. Col A - original date Col B - payment date - will contain blanks until paid Col C - delta between...