easy I'm sure if you know how - but I don't. Value of cells N26 and O26 are added together and result shown in P26 if both values in these two cells are zero (£0.00) I want cell P26 to be blank and not show a £0.00 value any ideas ?? thanks Use an IF function: =IF(SUM(N26:O26)=0,"",SUM(N26:O26) Andrea Jones http://www.allaboutoffice.co.uk http://www.stratatraining.co.uk http://www.allaboutclait.com "Anthony" wrote: > easy I'm sure if you know how - but I don't. > > Value of cells N26 and O26 are added together and result shown in...

I am trying to format a range of cells as a function of cell value compared with other cells. My attempts have failed so far. For e.g.: =OR(ADDRESS(ROW(),COLUMN())=$B$18,ADDRESS(ROW(),COLUMN())=$B$17) =OR(INDIRECT(CONCATENATE("R",(ROW()+1),"C",COLUMN()),FALSE)=B17) I do not wish to write VB code. Thanks in advance for any ideas. Maybe you could post what you are trying to achive it's hard to guess what you are trying to do -- Regards, Peo Sjoblom "Joseph" <Joseph@discussions.microsoft.com> wrote in message news:3331CF9E-E84E-44D0-8186-6F9E19DEE2...

I have calendar entires that are automatically forced to reoccur when I open and change the date. When I go looking for them on the date that I changed them to, they are not there. Instead, they are hidden in a reoccurance category section of the calendar system, not easily visible by the view that I use. These calendar entries do in fact reoccur regularly but I do not have an OL reoccurance setup on them - I like to manually change the date after I read it to a month forward for example. Oddly, after installing Outlook 2003 on my new Vista Ultimate machine this reoccurnce is being forced to...

If I have the following formula in a worksheet to bring up a message box =IF((F4-E4)>=15,PromptPayment()+F4-E4,F4-E4) How can I transfer some information from different cells to a new worksheet if the formula above works? Thanks Monty Hi formulas can't change other formulas. If you need such things maybe the following is interesting for you: http://www.dicks-blog.com/archives/2004/12/22/functions-that-do-things/trackback/ -- Regards Frank Kabel Frankfurt, Germany "Monty" <Monty@discussions.microsoft.com> schrieb im Newsbeitrag news:30A14E15-4B1D-47AA-8DDE-7969...

Hi, I have never programmed Excel before, but do use it a fair amount, including use of built-in formulae. I would like to be able to select a random value among a group of values - is this possible? So for example, in a spreadsheet I have in column A a list of names from cell 1 to cell 20. then I want to pick a name from random from that list. How would I do? Any input would be appreciated. -- Paul paulastya@gmail.com PS I do not have visual Studio/VB installed on my machine. someone else will give you a simpler formula, but, if not, the following will work: =INDIRECT("A"&a...

Hello, Is there a quick way to list out all the Distribution Lists that a particular user is the owner? When we have users leave the company, we constantly get requests to transfer ownership. Thanks, Sun Sun <Sun@discussions.microsoft.com> wrote: >Is there a quick way to list out all the Distribution Lists that a >particular user is the owner? When we have users leave the company, we >constantly get requests to transfer ownership. Not without writing a small script to query the AD. And, if the user account is deleted from the AD before you ask the question, you wo...

I have a sheet that pulls info from several other fields to create a text string. The problem is that I need all of the values from my other cells to be a tab space apart. Right now they are separated by several spaces, but it is throwing off my numbers. example, what I have: Name Date Value John 2.20.07 1 Dan 3.20.07 2 example, what I need: Name Date Value John 2.20.07 1 Dan 3.20.07 2 Franky 4.05.07 3 I imagine you have a formula like: =A1&" "&B1&" "&C1 so you are putting a fixed number of...

Code Double Feature Senior Pass Redemption Hubble COMP- staff Double Feature General IMAX- General Pass Redemption Hubble COMP Companion Gen Companion Snr Double Feature Child Double Feature General IMAX- Child* IMAX- Child* IMAX- General IMAX- General IMAX- Senior IMAX- Senior Pass Redemption Hubble Pass Redemption Hubble 2 for 1 DF- General 2 for 1- General COMP Companion DF Gen Csc- Corporate Single $5 Daycare- Adult Daycare- Child IMAX- Child* IMAX- Child* IMAX- General IMAX- General Pass Redemption Hubble COMP Companion DF Chd Double Feature Child Double Feature General Double Feature Gen...

I posted in another group but I don't think they understand what I am saying. Maybe you can assist me. I am using a template that is in xlt and in the shaded column I need the formula in L20 that is =if(D20<>"",D0*K20,"") I get an error stating that the shaded area is pre formatted by excel. How can I get my formula into the place where I need it? When I try to open the template to see the formulas it wants a password and I have never had a password. Question 2. How do you make your own template? I need one for a convention that has discounts deducted as wel...

Please somebody explains me what does this simbols means in a formula like this one:{=Sum(IF((B4:B7)=C17);G4:G7))} Please help me!! Tanx Alfredo, It means that it is an array formula. The formula is being used to resolve each cell in the array presented. So in your example, each cell in B4:B7 is tested against C17, and if true, the corresponding value in G4:G7 is returned, which gets summed by the SUM formula. You don't enter {} yourself, Excel does it when you tell it (Excel) that you want to use array formulae by typing the formula in and using Ctrl-Shift-Enter rather than just Ente...

Hi, I need to lookup a column if the value is between the first 2 columns Col 1 Col2 Col3 Col 4 1 5 Yes 10 6 10 Yes 20 11 15 No 30 If the value I am looking up is 7, I need to return Yes from Col 3. So if value is between col 1 and col 2, return Col 3. I was able to get Col 4 using Sum (if..) but do not know how to return the text in Col 3 Thanks in advance.. If column 1 is in E2 and Col 2 is F2 Col 3 = =IF(OR(E2<=$G$1,F2<=$G$1),"Yes","No") For column 4 I used =(INT(MAX(E2:F2)/$G$1)+1)*10 G1 is the number to di...

Maybe I'm overlooking the obvious...but I'm having a hard time groupin columns. Here's the goal: Columns A - L are the 12 months... Jan-Dec. I want to group 3 columns (3 months) at a time. So I'd have 4 colum groups side by side. I select the entire first 3 columns...data...group/outline...an group...creates the group fine. I then select the next 3 columns (next 3 months)...to be in their ow group. When I try to group them...it just ads them to the firs group...making one large group. The first 3 columns are not selected when I do this. I've also tried playing with the s...

I have several columns in an income sheet. One column has a sum at the bottom. I want to be able to run a simple macro that will copy the last row of formatted cells, just above the sum total, and insert it as a new row just above the sum total so another line of data can be input. But I want the sum total to sum also the newly inserted row. Presently I can't figure out how to do it. Example A B C 1 24 Oct Dollars In $100 2 25 Oct Dollars out $25 3 Total ...

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Power PC I can't believe that the navigation on this site is soooo bad that I have to ask this but how do I get to the old office 2004 forums that I used to get to from the old mactopia? Thank you irchamandy@officeformac.com wrote: > I can't believe that the navigation on this site is soooo bad that I > have to ask this but how do I get to the old office 2004 forums that > I used to get to from the old mactopia? The old Mactopia never hosted its own forums. Instead, it pointed folks to Google Groups <h...

All of a sudden, I have noticed that my column headings are 1,2,3, rather than A,B,C. How do I return them to A,B,C so that I can enter formulas? Tools > Options > General tab > uncheck R1C1 HTH George Gee "KAS" <KAS@discussions.microsoft.com> wrote in message news:B42F3AF3-80FD-486E-AFF6-B9AEA74858CB@microsoft.com... > All of a sudden, I have noticed that my column headings are 1,2,3, rather > than A,B,C. How do I return them to A,B,C so that I can enter formulas? ...

Hello Group Excel, I am using Excel 2003. My computation Columns are "E" to "J". Column "I" is the Total. Column "J" is the Running Total. With the following data: E F G H I J ..12 2.12 .09 -3.25 -.92 -.92 ..08 1.99 .03 -2.99 -.89 -1.81 ..10 2.05 .07 -3.15 -.93 -2.74 ((In the "J" Column when there is no)) -2.74 ((amount in Columns "E...

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Is there any way to find and replace cell colors in Excel? I know you can do this in Excel for PCs but is it an option for Mac users? > This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. --B_3347540289_42178790 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit On 1/28/10 2:34 PM, in article 59bb1c81.-1@webcrossing.JaKIaxP2ac0, "bbagby@officeformac.com" <bbagby@of...

I need to create a formula that references a range of cells. The range is supposed to be determined by what the user enters into another cell. Can a formula have a variable in it that will grab a number from another cell? For instance: =COUNTIF(N[B18]:N[B18+B18],"Y")? Where you see B18 the user has entered in a number, we will say it was 5. I need the function to reference the cells in the N column from N5 (cell B18 has a 5 in it) to N10 (B18+B18 or 5+5). I appreciate any help you all can give me. Thanks so much in advance. Brockettb Hi! Assume you enter in cells: A1 = 5...

Hi, I have this problem, What i have on hand is two column of data containing part number of two different devices. What i am trying to do is to compare this two column and find out all the part number that is common to both device and also which part number is unique. And organise and display this in excel. Anyone know any way to accomplish it please help. -- kuansheng ------------------------------------------------------------------------ kuansheng's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30658 View this thread: http://www.excelforum.com/showthread.p...

My spreadsheet looks like this: A 1 000000 2 182068 3 198506 4 200081 5 368010 6 580905 7 680001 8 686850 9 690060 10 700012 11 701068 12 802054 13 920211 14 968902 Using EDIT/FIND, when I enter '68' in the "Find What:" box, Excel finds A2, A5, A7, A8, A11 and A14 because their values contain '68'. What do I enter in the "Find What:" box to find the cells whose values BEGIN with '68'? (In this example, ...

I am trying to add up a column, but some of the cells have a space inserted (which need to remain there), however this is giving me #Value! instead of the correct answer - any ideas, please help - it's driving me mad! Tina "Tina" <anonymous@discussions.microsoft.com> wrote in message news:06196CE6-E1B4-4E19-A197-467B5B16D585@microsoft.com... > I am trying to add up a column, but some of the cells have a space inserted (which need to remain there), however this is giving me #Value! instead of the correct answer - any ideas, please help - it's driving me mad!! > &...

I have lots of groups with subtotals. I need to multiply the various subtotals by a factor (factors change depending on the group) that's in its own column and then get the product (which needs to be an even number (rounded up). Those products need to be added to the subtotal - which should now give a new subtotal for the group. Then those new group subtotals need to be added to get a Total. All I get are "0" when I try to do this. And I'm under a deadline. Is there anyone out there who can help???? Thanks. url:http://www.ureader.com/gp/1027-1.aspx It sounds as if ...

I'd like to create a macro that fills a formula down to the final row that has any data. -- Just filling to adjacent cells (e.g. double-clicking on the autofill button) doesn't work because some of the rows don't have data in the cells the formula is looking for. -- I know I can select all the cells below the one I entered the formula in and hit ctrl-D to fill the formula, but I need this macro to be able to run no matter how many rows of data are present. -- I tried filling the fomula all the way past the highest row number I'd ever thought I'd reach but then ...

I need to know how to protect only the cells that have a formula in them, and still allow editing of other cells. How. You can select special ranges by: ctrl-A to select the whole sheet Edit|goto|Special click on Formulas (or constants or blanks) Now you've just selected all the formulas (or constants or blanks). Format|Cells|Protection Tab Check Locked or uncheck Locked (depending on what you selected) Now protect the worksheet. Tools|Protection|protect sheet. ==== Depending on how many cells I want different, I'll select everything and unlock them. Then come back and lock ju...

I have some simple raw data corresponding to five variables. I am constructing a table where, given a value for one of the variables and using the FORECAST function, the predicted values for the other four variables are calculated given the correlation of the raw data. However, I would like to make this table dynamic - so that I could input a value for ANY one of the five variables and return the expected values for the other four. As of now I do not know how to do this. Perhaps if there was a way to preserve the formula in each of the cells while still being able to input an arbitrary value....