In the examples below, is it possible to combine the 2 formulas into one? I need to simplify my spreadsheet if possible. IF(M3>=H1,IF(MAX(H3,H7,H11,H15,H19,H23)>=MAX(H5,H9,H13,H17,H21,H25),1,2 IF(M4>=H1,IF(MAX(h3,h7,h11,h15,h19,h23)<=MAX(h5,h9,h13,h17,h21,h25),2,3 Thanks very much for any help.

0 |

5/28/2010 7:46:01 PM

As they have different tests/outputs, how do you want them combined? Also, there are two IF functions, but only one set of outputs. Perhaps these are an AND condition? A simple way (with a lot of assumptions made): =IF(AND(M3>=H1,MAX(H3,H7,H11,H15,H19,H23)>=MAX(H5,H9,H13,H17,H21,H25)),1,2)+ IF(AND(M4>=H1,MAX(H3,H7,H11,H15,H19,H23)<=MAX(H5,H9,H13,H17,H21,H25)),2,3) -- Best Regards, Luke M "DebC" <DebC@discussions.microsoft.com> wrote in message news:12C50B6E-A0FA-4CC0-88BD-17A8DFAC1BB0@microsoft.com... > In the examples below, is it possible to combine the 2 formulas into one? > I need to simplify my spreadsheet if possible. > > IF(M3>=H1,IF(MAX(H3,H7,H11,H15,H19,H23)>=MAX(H5,H9,H13,H17,H21,H25),1,2 > > IF(M4>=H1,IF(MAX(h3,h7,h11,h15,h19,h23)<=MAX(h5,h9,h13,h17,h21,h25),2,3 > > Thanks very much for any help.

0 |

5/28/2010 8:00:34 PM

I need to show on a weekly basis, the number of weeks left in the year. I don't want to have to enter it, I want Access to calculate it for me and show it on my report/database each time it is opened. For example , I want to say there are 34 weeks left in this year. Is there a formula I can usethat will determine the number of weeks remaining from today's date (whatever it is) to December 31? One way to look at this is that, if you can identify the "week" of the current date, you can subtract that from 52 to get an idea of how many weeks are left. .... o...

Hi Using Excel 2003. In sheet 1, cell A1: =200/1200 In sheet 2, cell B2: =300/1200 In sheet 3 in a cell, I want to do =200/1200 + 300/1200 by cell reference. How do I do so? Thanks. Your formula would be: =sheet1!a1+sheet2!b2 The best way to create these formulae is to get Excel to do it. 1: Type = into your cell 2: Navigate to your sheet1!a1 cell. You will notice in the formula bar that Excel is adding its address to your formula 3: Type + 4: Navigate to your sheet2!b2 cell. 5: Hit enter Once you learn this, you will never type a cell address again. Regar...

HI, I mistakenly delete all mails from Inbox and then found them on the deleted Items and selected all and ask to move folders back to Inbox. the problem is all mails were combined into one email and moved back in to Inbox as a single email. How do i go back to the original version. How do i uncombined all the mails in to individual mails from the right recipient? Please help ASAP.. Submitted using http://www.outlookforums.com ...

I have a problem that i don't know how to solve. I wrote it all in my excel file that needs to be done. File is here http://www.sendspace.com/file/q4jc71 Anything that isn't clear, pls ask me. I need this really badly, because my tables sometimes have thousands of those records. HTH: http://excel.tips.net/Pages/T002581_Sorting_Data_Containing_Merged_Cells.html Micky "domyrat" wrote: > I have a problem that i don't know how to solve. I wrote it all in my excel > file that needs to be done. > > File is here http://www.sendspace.com/fi...

Here is my problem. I set up our office managers Email to Open our presidents Mail. She is set up to view all his Folders Inbox,deleted,sent ect. I also set up here to view our vice pres. I cannot for the life of me remember how i did that. I have to set her up to view another persons mail. When I try, It just sucks thier mail into her inbox instead of showing the individuals folders. Can anyone Help me. We are useing outlook 2002. Thanks for any help. Steve Exchange server? Open the account using tools, accounts... and on one of the tabs, you add the mailbox. -- Diane Poremsky [M...

I need to merge about 75 worksheets into one spreadsheet on a regular basis - all have exactly the same format/layout etc back can vary in the number of rows Try this Jeff http://www.rondebruin.nl/copy3.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Jeff224" <Jeff224@discussions.microsoft.com> wrote in message news:C6790506-2888-4F4D-80EA-BB0D9F9B27A2@microsoft.com... >I need to merge about 75 worksheets into one spreadsheet on a regular basis - > all have exactly the same format/layout etc back can vary in the number of > rows Or http://www.rondebru...

Hi everybody i have a list on excel 2007 that displays the purchase of items on columns A:E, each column showing one (1) item I want to find what combination of items appears more times, especifically, which combination of four (4) is the favorite mix eg: A B C D F A C D E F B C D E F B C D F Z in this example, the winner would be (B, C, D, E) as it appears 3 times the main problem is that I have over 1,000 rows and trying with =SUMPRODUCT(COUNTIF(A1:E1,$N$1:$R$1)) por each combination would take forever... is there a simpler, quicker ...

Custom format of [>=10000000]##\,##\,##\,##0.00;[>=100000]##\,##\,##0.00;##,##0.00 -- HTH Bob Phillips "debiprasad" <debiprasad@discussions.microsoft.com> wrote in message news:05D085CE-42D1-47E1-ADCA-4F0DA80AA739@microsoft.com... > ...

I have in column A1:A365 all dates of the year 2005 and in colum B1:B365 the days of that date. In column D1:D365, E1:D365 and F1;F365 I fill in a X for every actio Succeeded. SO if it is 1 January 2005 and the action in D1 and E1 and F1 are al succeeded I fill in those fields an: X I have in a cell a formula what checks how many % (procent) succeede of the fields who are filled. But when it is December he also calculates the X that are filled in A etc. Now I would like to make a formula which calculates how many action went good in the last 30 days is this possible? So that he only chec...

Hello Excel disciples, =A0 =A0 I wonder if I can run this past you? =A0 =A0 Lotus 123 had a facility that you were able to build "Dynamic" formulae ie; =A0to construct using text and ranges to create valid formulae. =A0 I have several worksheets name Team 1, Team 2, Team 3, each identical etc I have a consolidation worksheet that takes numeric values from a cell from= each and sums the total. =A0 In the Totals sheet columns above the values column is the team name in= text. =A0 =A0 =A0Team 13 =09=09Team 14=09=09Team 15 etc =A0Grd1 =A0Grd2 =A0100 =A0=09375 =A0100=09=09375 43.5=09=09...

I have 2 xls workbooks with different sheet names and both with different range names. I would like to combine them both into one workbook so that I don't have to re-create all of the range names. Is there a way to do that? -- LAF ------------------------------------------------------------------------ LAF's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9656 View this thread: http://www.excelforum.com/showthread.php?threadid=346017 Hi LAF- Open both files (let's call them A & B, and assume A will be your "combined" file). Working i...

Hi I run Excel 2K I download data from a mainframe. This data has a date & time format in it (dd/mm/yyyy hh:mm:ss) I work in a place that has a 3 shift cycle - day shift, afternoon shift, night shift. Day shift starts at 7:20am and ends at 15:29pm Afternoon shift starts at 15:30pm and ends at 23:19pm Night shift starts at 23:20pm amd ends at 7:19am I need a formula that looks at the cell with the date/time in it and displays the word DAY (for the time frame of day shift), AFTERNOON (for the timeframe of afternoon shift) and NIGHT (for the timeframe of night shift) In my previous ...

hi, When I am trying to post entry from Fixed Assets to GL the following errors will BE occur in Microsoft GP 10.0 "The stored Procedure aagUpdateBrowseTypeForBRVoiedT=ADRX returned the following results: DBMS:8114, Microsoft Dynamics GP: 8114." Kindly help me out to resolve this problem.. ...

In exchange my user account is set-up with 2 smtp addresses. 1) Erik@mycompany.com and 2) jreed@mycompany.com (this is the primary SMTP address) so any email sent to those 2 addresses comes to my inbox. I tried to create a rule in outlook XP to place the email to erik@mycompany.com into a seperate folder. Turns out that this can not be done! OUCH! it appears all incoming mail is translated to the local account name and the smtp address is not referenced at all???? I do not want to have to create a seperate user and maintain 2 different mailboxes. I have to be missing how to do thi...

Is it possible to refer to text in a cell as though it were a formula, ie execute it instead of displaying it? Eg if the result of your formula was "A1 + B2", to actually add A1 and B2 and display the result? Thanks Nigel Like concatenating text? =concatenate(a1," + ",b2) or =concatenate(a1,b2) =concatenate(a1," ",b2) "Nigel Ramsden" wrote: > Is it possible to refer to text in a cell as though it were a formula, ie > execute it instead of displaying it? Eg if the result of your formula was > "A1 + B2", to actually add A1 and...

I have a problem. I looked in my MDBDATA folder and I have 1,711 Log Files that are 8.4GB. How do I remove these? I need this done as soon as possable. I am running out of HDD space. Thank you, Jason. a full, online backup of the storage group will purge these files... -- Susan Conkey [MVP] "Jason" <Jason@discussions.microsoft.com> wrote in message news:0ACF715C-A102-4F43-8DD7-4551B680DC14@microsoft.com... > I have a problem. I looked in my MDBDATA folder and I have 1,711 Log Files > that are 8.4GB. How do I remove these? I need this done as soon as possable. >...

How do I sum cells that include #N/A in the range. The #N/A is the result of a lookup formulae. I want such cells to register as 0. Currently the sum of the cells gives #N/A as the answer. Thanks Heather Use the ISNA function, thus =IF(ISNA(ExistingVlookup),0,ExistingVlookup) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "HeatherC" <HeatherC@discussions.microsoft.com> wrote in message news:0B8888EE-F35C-4F5A-B1DE-BCF24DF870E6@microsoft.com... > How do I sum cells that include #N/A in the range. The #N/A is the r...

Can I combine two different publications into one? Suzi wrote: > Can I combine two different publications into one? ========================================= Personally, I would simply open two instances of Publisher (one document in each) / tile the two screens...and copy/paste. Maybe the following link will be useful: Combining Publisher Documents http://tinyurl.com/2lpj5w -- John Inzer MS Picture It! - Digital Image MVP Digital Image Highlights and FAQs http://tinyurl.com/aczzp Notice This is not tech support I am a volunteer Solutions that wo...

I am trying to write a formula that will do the following: if a cell i fill in with color, do not sum values, otherwise sum values. However I do not know what the fill variable is to put in the formula. Hop this make sense. Please help. Thank You -- Message posted from http://www.ExcelForum.com Hi gardener! See: Chip Pearson: http://www.cpearson.com/excel/colors.htm Watch out for colors that result from conditional formatting as they are treated differently from "manually" imposed colors. -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Exc...

Kindly suggest what is the best way to reference the following in excel formulas: +) last row of a worksheet that has some data +) last column of a worksheet that has some data Regards, Sandeep Hi Sandeep In VBA the best thing is to use this functions You can use this in your code then for example Lr = LastRow(Sheets("Sheet2")) Function LastRow(sh As Worksheet) On Error Resume Next LastRow = sh.Cells.Find(What:="*", _ After:=sh.Range("A1"), _ Lookat:=xlPart, _ LookIn:...

Hi, I have this named formula (insert, name, define) where the name is "test" and the formula is: ="Data'!$R"&(MATCH($D$35-$D$36,Data'!$A$13:$A$513)+12)&":$R"&(MATCH($D $35,Data'!$A$13:$A$513)+12) which outputs a text data range; 'Data'!$R22:$R71 which is exactly what i want. what I now want, is to plot the values in this data range. How can I do this? Phil In the Chart Wizard, enter =test in the Data Range input box. In article <1172498256.928768.226590@a75g2000cwd.googlegroups.com>, "Phil Newman"...

Hi Everyone I need help in this issue. I have tried many ways though some wer successful but they were not efficient. I have say 5 columns of data and the data could be on the same rows o all 5 columns or on different rows hence if I need to combine all th data of these 5 columns, I would have to sort or filter each of the manually and copy and paste to a different worksheet or column. This i very tedious and time consuming. I also tried to write a macro to loo for data in one column then put them into another column but i was no successful. However, experts like you guys shouldn't have ...

I have a finite number of values that represent length (right now I have less than 20 values). Can Excel take these values and list all possible combinations of the values? Any pointers appreciated. Stephen R. Stephen, No. There are 2,432,902,008,176,640,000 possible ways to combine 20 different values. That is, unless you have another limitation, like only using 4 at a time.... HTH, Bernie MS Excel MVP "Stephen R" <nospam@nospam.com> wrote in message news:u9ZiYhOeFHA.1456@TK2MSFTNGP15.phx.gbl... > I have a finite number of values that represent length (right...

I installed Office Standard Edition 2003 SP 1 recently but did not elect to install Excel as part of it -- now I find I need Excel and would like some guidance as to how to install it. There are two discs as part of the Office 2003, one has "Product Key Required" on it and the other "Service Pack 1" on it. Otherwise, the disks are largely identical. Thanks for any guidance. John what operating system? to to control panel, add remove programs or programs in vista/win7. select the office installation and select change. add excel. you may or may not ev...

I have a line chart (looks like an S curve graph) with two rows of data below & this chart looks exactly like I want it to. Period % Complete Dec-04 7% Jan-05 9% Feb-05 10% Mar-05 12% Apr-05 14% May-05 19% Jun-05 22% Jul-05 23% Aug-05 24% Sep-05 26% Oct-05 28% Nov-05 32% Dec-05 36% Jan-06 40% Feb-06 45% Mar-06 50% Apr-06 55% May-06 59% Jun-06 63% Jul-06 66% Aug-06 71% Sep-06 75% Oct-06 78% Nov-06 81% Dec-06 85% Jan-07 87% Feb-07 89% Mar-07 91% Apr-07 93% May-07 94% Jun-07 94% Jul-07 95% Aug-07 95% Sep-07 95% Oct-07 95% Nov-07 95% Dec-07 95% Jan-08...