OR Function #4

I am trying to make a formula using the if function.  However, within this 
formula I need to nest an OR function.  I can not get it to work.  Any 
suggestions?
0
10/3/2005 5:55:03 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
480 Views

Similar Articles

[PageSpeed] 34

=IF(OR(A1=condition1,A1=condition2),output_for_true,output_for_false)

-- 
Regards,
Dave


"frustratedwthis" wrote:

> I am trying to make a formula using the if function.  However, within this 
> formula I need to nest an OR function.  I can not get it to work.  Any 
> suggestions?
0
10/3/2005 6:02:05 PM
Reply:

Similar Artilces:

User Defined Function
How would I write a MinIf function that could be used in the spreadshee in the same way the "CountIf" function is used. It would be great to be able to min a range, selecting all values abov zero. Any thoughts greatly appreciated -- Message posted from http://www.ExcelForum.com Try something like: In B1: =MIN(IF(A1:A100>0,A1:A100)) Array-enter with CTRL+SHIFT+ENTER (instead of just ENTER) -- Rgds Max xl 97 --- Please respond in thread xdemechanik <at>yahoo<dot>com ---- "dovrox >" <<dovrox.17tzmb@excelforum-nospam.com> wrote in message news:...

formula help #4
I could use some help in creating a statement that avoids the div/ error in the following formula =SUM(((G4/G40)*J40)+((L4/G4)*J42)+((Q4/G41)*J41)) at any point G4,L4,Q4 could be a value of 0. G40,J40,J42,G41,J4 always have values. I'd like the cell to show a value of 0 when there are not any value for G4,L4,Q4 THANKS ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements T...

units #4
Hi, I'm needing to adjust the height of the cell but the measurement is in pixels, can I change it to inches? Mindy http://209.196.177.41/01/01-09.htm -- Regards, Peo Sjoblom "Mindy" <Mindy@discussions.microsoft.com> wrote in message news:B045AFC8-3DDD-47EE-986C-E49BC10B4CF7@microsoft.com... > Hi, I'm needing to adjust the height of the cell but the measurement is > in > pixels, can I change it to inches? Mindy Note that row heights are measured in points, there are 72 points to the inch pixels are video card dependent (resolution etc) -- R...

Pivot Table help #4
I have a list of data with the following columns (Location, Item #, Late, Late if not rec'd today, Late if not shipped today). The last three have an "x" to indicate status and there are several blanks. I created a pivot table that had Location in the Page field and Count if Late, Count if Late if not rec'd today, Count if not shipped today in the data field. My pivot table is accurate but when I double click on a total for say Late, I get a full list of all items for that location, not just the late. I tried putting location in the Row field but got the same resul...

arrow keys #4
Did a search of your posted messages - yes, he had his scroll lock key on!!. Thanks, you guys are great. ...

Error "propagating language setting" when starting CRM 4 for outlo
Hi, I have a new installation of CRM 4. My webclient works fine. When I install the client for outlook on my outlook 2003 the installation passes without any problem. I then go throug the configuration without any problems. When I start outlook it is stucked on "propagating language setting". I have tried on four different clients with the same result. Any idea??? I have the same issue at the moment. I will post here if I figure it out. Please do the same if you do. "Tobias" wrote: > Hi, > I have a new installation of CRM 4. My webclient works fine. When I i...

Address Lists #4
This is a multi-part message in MIME format. ------=_NextPart_000_006A_01C524AC.4E5782E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Does anyone know of a solution (MS, script or 3rd Party) to get the = 5000+ external contacts I have in public folders into an address list? = I know how to set that up on clients to display the public folder. Some = people need access to 5 or so different PF and we are looking at various = CRM solutions that would created more nested public folder contact = lists... just looking for another solutions...

office 2004 (excel & word) afp file path issue on tiger server (10.4.9) #2
g'day, we have just changed over to an xserve (running 10.4.9, HFS+ with ACLs) and are experiencing the following problem with office 2004 excel & word files only - surprisingly powerpoint files are not affected: all excel and word files without spaces in either file- path or -name open just fine, however all files with spaces in file-path or -name generate the following error message... <img src="http://homepage.mac.com/daniel.schagemann/posts/EXCEL_1.png" alt="excel error message" /> for the above we used the following example file: -rwxr--r-- 1 daniel...

prompt for function arguments?
I have a macro that calls a function with 2 arguments: Import (file path, state) This function is importing excel files into an access database. I have to import a file for all 50 states. Is there a way to set something up that when the code is run, it will prompt for the file path and state? Thanks in advance for any help. You can base your path and state off unbound fields on a form so that those fields would need to be populated before running the code. If the paths stay the same for each state, it sounds though like you might want to make a table to store the path and state and...

SumIF function #12
I apologize for not making myself clear. I appreciated the response. And allow me to qualify my original question further. I know I can do a pivot table and obtain the results, but I am trying to avoid that. See my example below - the question is how do I do a sumif function within a summary view when I want to recap hundreds of rows by alpha FERC Codes and sum associated values within the aging bucket column? I included an excerpt of 5 records under 4 column headings, and then I show the summary of those five records below by FERC Code by aging bucket. The countif function work...

CRM 4.0 Knowledgebase fields
Hello, I'm attempting to dump out the fields from the Knowledgebase section of the CRM to eventually use them for our customer knowledgebase on our web site, but am having a difficult time handling one of the fields. The field in question is called "articlexml" and if I dump them out via SQL, it contains what appears to be some xml related data. ...I'm not good enough at my parsing skills to remove it, so I was wondering if anyone had any insight to this issue. Here is a sample of one of the entries in that filed (some content removed for simplicity) <articl...

CRM 4.0 - Word 2007 - mail merge
OK, so I've read a number of blogs detailing the mail merge process. Open in Word, save as XML, import to CRM, edit and add the mail merge fields. Simple, right? My organization has about a dozen mail merge templates which worked very well in CRM 3.0. I was fully aware I would probably have better luck just re-creating them in CRM 4.0. No biggie. I've done so and mail merge in CRM 4.0 is ... shall we say less than stellar. Mail merge on the Contact entity does not work at all. For any user. Mail merge on the Account and Opp entities works sporadically. Literally from one user to th...

Quartile Function
I would like to use a formula to return which quartile the given data array falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%, etc. The quartile function only returns the value of the various quartiles, while I need to know within which quartile the value falls. Any help is appreciated. On Tue, 15 Mar 2005 01:01:02 -0800, "tika528" <tika528@discussions.microsoft.com> wrote: >I would like to use a formula to return which quartile the given data array >falls into- that is I would like to return 0,1,2,3,4. 0= min, 1=25%, 2=50%, >etc. &g...

CRM 4.0 VPC Problem
I downloaded CRM 4.0 VPC, extracted them, and I got MSDYCRM40VPC_BASE.vhd. After I create a new virtual machine for this vhd, I got an message "Reboot and Select proper Boot device or Insert Boot Media in selected Boot device" when I clicked Start. So, it have not brought me to WINDOW LOGIN SCREEN. Anyone had this CRM 4.0 VPC worked, please help me how to get it work to get away from a message above. Thanks and Appreciations -Toi "Toi Day" <ToiDay@discussions.microsoft.com> wrote in message news:50BF3D76-10D8-4CF0-90BC-EFF8E0D925A0@microsoft.com... > I...

sumif using the now() function
I am trying to sum numbers using the NOW() function as my criteria, however no luck. sumif($D$1:$BC$1. ">=NOW()", D2:BC2) Any help would be appreciated. Thank you Try this: Assuming you try to sum D2 to BC2 on your example. =if($D$1:$BC$1>=Now(),sum(D2:BC2),"" -- renega ----------------------------------------------------------------------- renegan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1045 View this thread: http://www.excelforum.com/showthread.php?threadid=52871 renegan: Thanks for your response, however I got #VAL...

On-Premise - Outlook CRM Client 4
We're having a multitude of issues with our CRM for Outlook Client. These issues have just started accross multiple users since CRM was installed last month. 1)Many machines running Outlook 2003 / 2007; current patches with the Microsoft CRM4 (RU5)Outlook client installed. When creating or replying to a HTML, or RTF, e-mail sometimes even though the cursor is in the body text area, the formating toolbar will be greyed out (as if it is a plain text e-mail) unless the user right clicks in the toolbar area of the message which apart from bringing up the toolbar customization menu ...

Dynamic change of worksheet reference in a Hlookup function
Hi, I am a basic user of MS Excel, and starting to use hlookup function. In this function i have the worksheet reference that i want to change linked with a cell in another worksheet. The problem: - HLOOKUP(Info!$D$10;'02545'!$A$1:$Z$219;70;FALSE), - Want to change '02545' for the cell "Info!$D$11" which has th worksheet reference, that i can change for another worksheet within th workbook. Thanks for the hel -- fariapedr ----------------------------------------------------------------------- fariapedro's Profile: http://www.excelforum.com/member.php?a...

Public Folder Replication error #4
We have windows 2000 domain, exchange 20003 running on windows 2003 member server, we have to windows 2000 sites, all AD replication is OK, but only public folder replication did not happen, between two servers, I am getting following NT event application event error EVENT ID 3093 Error -1603 reading property 0x36010003 on object type tbtFolder from database "First Storage Group\Public Folder Store Also I have following event 3085 Error 0x8004010f occurred while generating an outgoing replication message. Type: 0x4 Folder: (7-3ABC) Database "First Storage Group\Pub...

Inability to design functional reports or workflow processes
Standard across the board everyone must want the following capabilities To create a Report whereby All Accounts with no Activities past 2 months can be shown All Accounts with no Opportunities past 6 months can be shown Is there a possibility of including this in a View? (Optimal) Is there any possibility of creating a report with c360? (Workable) At the weekly sales meetings Division Management wants to not only go over the positive but also the negative such as which major Accounts have gone without activity and need to be reassigned to other Salespersons. Chuck: I have tried everything t...

Business Portal installation error #4
I am installing business portal (for gp ver 10.0) dynamics db and company db are upgraded from 8 to 10. when I am installing BP an error mesage coming and BPSQLlog files shows : "Database: "n/a" Actor: "SQL.VBS_LoadSQLComponent()" */ ERROR: Path (C:\Program Files\Microsoft Dynamics\Business Portal\Utilities\SQL\Upgrade\2.5.1173.0\System\GP_COMMON\) did not exist." and continue installation and will finish sucessfullly. But portal gives unnown error. Please help me! One more error is "Failed Loading Packager Data Element (PD_GP_COMMON) for Inst...

using color for if function
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) For instance, I would like to make the sheet operate so as, <br><br>If a number is positive, it is black <br> If a number is negative, it is red <br><br>instead of manually changing the color of each negative number On 3/4/10 11:24 AM, surfishingfool@officeformac.com wrote: > Version: 2008 Operating System: Mac OS X 10.5 (Leopard) For instance, I > would like to make the sheet operate so as, > > If a number is positive, it is black > If a number is negative, it is red > > i...

NZ Function and Null VS 0 values
Here is my question, I have the following statment in a query: PostSumCreated: Sum(NZ([Post_Sec2_7CreatedTotal]) +NZ([Post_Sec3_5CreatedTotal])+NZ([Post_Sec4_3CreatedTotal]) +NZ([Post_Sec4_5CreatedTotal])+NZ([Post_Sec5_4CreatedTotal]) +NZ([Post_Sec6_7CreatedTotal])+NZ([Post_Sec7_4CreatedTotal])) This returns either the number of the addition or 0. The problem is that I have NULL values in the table, where 0 would represent that yes nothing was done and Null would represent that nothing was support to happen. What I need help with is trying to add the needed columns if they have a value >...

Product Key #4
I have a problem. I am working on a poster for a presentation, and someone suggested that I use Publisher. I tried to launch, but it is asking for my Product Key. I am working on my work computer, and it was here when I got here, so I don't know the product key. How can I find this? My IT guy says he doesn't have it. If it's Publisher 2000 or older you're up the creek without a paddle. But if it's a later version of Publisher I believe BelArc Advisor will show it to you. For Publisher 2000 (the version I use) the Product Key looks similar to a Windows ProductKey, 5 ...

If-Then Statement #4
Column A = Part Used (not needed for this part) Column B = Weight of Item Column C = Company Used (I found this using If-Then, an easy one..) Column D = Price Paid Column D is what I am trying to figure out.... what price they pai according to the weight of the item. So if the weight was 5 pounds, they used Quick Freight and paid $3. If the weight was 10-50 pounds, they used Quick Freight and paid $20. If the weight was 51-70 pounds, they used Gamecock Freight and pai $40. If the weight was 71-90 pounds, they used Gamecock Freight and pai $46. So for Column D, all the answers will eith...

DEFAULT FONT #4
Referring to my previous message and just working on this now, I have discovered that if I create a template with the font style I want, I can use this instead of the normal template that comes up automatically on opening Publisher. It does mean always going to FILE/NEW/Templates but at least I can make it work. Would be grateful to hear if anyone else has any better idea. Thanks, Tina ...