or function

Hi everyone, This is my first post, so thank you everyone for all the help I'm sure I'm going to get! I am trying to write a formula using the IF function and OR function. I basically want it to say: IF (OR (certain cell = this, certain cell = that, ""), __________) The _____ is that if the...

Hi I don't normally post in forums as generally find someone else has already asked/answered my questions but I just can't solve/find the answer to this one so would appreciate any help you can give! I also was not able to download the .xla to post a table using the required system so have...

Hi All, Reference to this thread http://www.mrexcel.com/forum/excel-questions/423808-use-lookup-formula-mid-function.html I want to use same formula in bit different way. But I can't figure it out how? I have a Date "26 January 2013" Sheet 1 <tbody> A B C D 1 Name "ABC" Contract start...

I'm sure this has been answered already, I just can't find it. I'm using Excel 2010 on a windows XP operating system I'm struggling to create a condition in a cell which I will be using later to export data for a sales training progress report. In cell A1 there will be one of 4 things : A) N/a...

Hey guys, Just looking for a quick bit of help. Looking to use averageif for two conditions. Normally I'd use the averageifs formula, but, it's not two conditions on one value it's one value where it can be A or B. I've even tried the OR function with no success... So, what I've tried to do...

I am stuck on how to make a formula that would count how many people in Section B telework on the First Monday of the pay period. The Telework data is in 4 different columns. I am stuck on using the And/Or operators. Any ideas? Countifs(C:C,"Section B") And countifs(F:F, "Monday P1") or...

Hello, I am gathering a large amount of data and from that data I need to extract the following: One column has values ranging from 1 to 20 lets say A1:A500, and the 2nd column has the same values ranging from 1 to 20 (B1:B500). What I need to do is check if say A1 or B1 is less than 11. If...

Hi I'm tring to use the following formula to return a blank if B6>5 or there is an error value such as #DIV/0!. However, any cells that contain an error values such as #DIV/0! still show #DIV/0! =IF(OR(B6>5,ISERROR(B6)),"",B6) Appreciate your help!

I would like to sum data in a database based on responses to to several check boxes that relate to two fields in the database. A user can select any or all of 7 options for each field, the options having to do with types of technology the user wishes to view and various size ranges. How can I do...

Hi, I am trying to link two sheets in the following way and for the purpose of ease I'll call the sheets A and B. IF cell B18 in sheet A is greater than cell B46 in sheet B AND cell B18 in sheet B is equal to 1 OR 5 OR 10 OR 15 OR 25 OR 50 then cell B90 in sheet B should equal cell B18 in...

Hi, I'm new here! please be patient with my problem! I would say I have a basic grasp of excel and have been working with it for several years. Using excel 97 on XP. I am creating a formula, in effect to return a result in a Gantt chart, which references times and returns "1" or "0" if true...

This is probably an easy one. I'm testing the use conditional formatting using a formula. The rule description is : =C4=OR(C7,C9) Where C4 is a drop down list selected from a list in C7:C8. Basically, to test, I'd like to make a selection in C4, and if that value is equal to the value in...

I'll try to phrase my question as clearly as I can so that you wonderful people can help me! ;) I have Column A and Column B with Data, Column C is where I want to do the Formula and Column D is where I have the labels. Column D is where we label a certain piece of business as registered...

So far my formula does the following: If cell "E19" = 11 and "F19" = 11 Display what is in cell A42 in sheet Working Strategy Otherwise Do the sum cell "D22" - "B19" in sheet Working Strategy Here is the following formula:- =IF(AND(E19=11,F19=11),'Working...

I have the following formula: =IF(OR($B$8>'Working Strategy'!$P$3,$D$22>=18),"STAND",IF('Main Console'!$B$8<='Working Strategy'!$P$3,"HIT")) This always displays "HIT" in the cell the formula is written in, is there anyway i can keep the cell blank untill some data is written in to trigger...

EXCEL 2010 I am trying to do the following IF in sheet "Main Console" cell "E19" displays an 11 and "F19" Displays a 9 OR cell "E19" displays a 9 and "F19" displays an "11" AND cell "G19" displays a 3 show the following - 20% otherwise display blank Here are the formula's I have tried...

Hi All, I am trying to create a IF that has a nested AND. (i think) The steps it needs to take are as follows... 1. checks GDueDate is >=TODAY()+10,"Ten Day Plus", 2. checks GDueDate is >=TODAY()+3,"Three Days Warning", 3. checks GDueDate is >TODAY(),"Standard Due Today", 4.a checks...

Hi Guys I've got a sumproduct formula, and saw from another post how to add in an OR function. Its working but what I need it to do is to exclude if it meets the OR function: =SUMPRODUCT((rABReseller="Non-AB Reseller")*(EPP_Rev_Strm="New...

I have a formula construction question. Below is the formula I have. (I am looking up the number of wins a certain team has). The lookup is looking this team up on the 'Team1' range, however, sometimes the team I am looking up may not be in this range and on the 'Team2' range, or in the 'Team3'...

Hi guys, Is there any way to use ranges in AND and OR? For example: Currently using: OR(A1="",B1="",C1="",D1="") Would like to use something to the effect of: OR(A1:D1="") Is this possible? (keeping in mind I want to use less code) Cheers