Pete Check out Tools>Options>Calculation. Is is set to "manual" or "Automatic"? Gord Dibben Excel MVP On Sun, 14 Dec 2003 10:51:10 -0800, Pete S <psimler@twmi.rr.com> wrote: >I have completed a five sheet program for monitoring Mutual Fund Data. All of the formulas acted normally until I completed a sixth sheet to summerize the data. The formulas on the sixth sheet link back to the other five sheets. Upon completetion of the sixth sheet none of the formulas in the preceding five sheets will work. Help

0 |

12/14/2003 8:29:20 PM

I am trying to set up a spreadsheet to show the costs, after rebates, for a solar array. They rebate for New York is $1.75 per watt. That would be an easy formula of: =the number of watts*1.75, or =(C9*1000)*1.75 on my spreadsheet. However, they only reimburse a customer up to 5000 watts. what formula can I use to get excel to properly calculate this cell? Thanks for any help possible, Kyle Parenzan Hi Kyle =MAX(5000,(C9*1000))*1.75 -- Regards Roger Govier Kyle P. wrote: > I am trying to set up a spreadsheet to show the costs, after rebates, for a > solar ...

Hi, Access Users, Good Day, I would like to calculate two feilds in quary for days but formula "DateDiff() is giving correct answer. I would like to have your half, please. Regards, Wajid wajidalibwp@msn.com Wajid <Wajid@discussions.microsoft.com> wrote: > Access Users, Good Day, This is the Outlook newsgroup. -- Brian Tillman ...

I am trying to create a formula that will take information from a cell on one sheet and combine it with text on another sheet. I know how to get the two together. My problem is that I want the part that is brought in to be bolded type. Here is what I have in the formula. ="we are pleased to submit our quotation for "&(cell reference)&" according to the following specifications." What I want to do is have the cell reference part be bold type. Is there a way to do that? It doesnt work if I bold the cell.. already tried it.. Any suggestions? Thanks! KK You'...

I am using Excel 2007 and need some helping on a rounding formula. I would like my cell to either round to the nearest whole num or ".5" of the number but it needs to round down. For example: 5.1 would round to 5.0 5.4 would round to 5.0 5.5 would round to 5.5 5.7 would round to 5.5 5.9 would round to 5.5 6.0 would round to 6.0 I am using the Mround function but that rounds up so 5.8 and 5.9 rounds to 6.0 but I need them both to round to 5.5. Any thoughts? Thanks! Sorry please delete. I moved this to the Excel Functions forum. "duketter" wrote...

I need to write a PRODUCT array =PRODUCT(1+(the values in column t that have a value in column d that match the value in D841)-1) Is there a way to do a PRODUCT like a SUMIF? ex: =SUMIF(D:D,D841,M:M) It's to replace this formula: =((1+T654/100)*(1+T671/100)*(1+T688/100)*(1+T705/100)*(1+T722/100)*(1+T739/100)*(1+T756/100)*(1+T773/100)*(1+T790/100)*(1+T807/100)*(1+T824/100)*(1+T841/100)-1) I think this array-entered** formula will do the same thing as the long formula that you posted... =PRODUCT((1+(T654:T841*(MOD(ROW(T654:T841)-8,17)=0))/100)) **Commit formula using Ctr...

Hi, anyone know how too make a formula inn excel that can find how many days there are left too "for exsample when people turn 50 years from their birth? Try: ="Will be "&DATEDIF(A1,TODAY(),"y")+1& "in "& IF(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))>TODAY(),DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))-TODAY(),DATE(YEAR(TODAY())+1,MONTH(A1),DAY(A1))-TODAY()) &" Days time" or with a bit more text: =IF(DATE(YEAR(TODAY()),MONTH(A1),DAY(A1))=TODAY(), "Birthday today!","Will be "&DATEDIF(A1,TODAY(),"y")+1&...

Say I have a worksheet with the following information: Name Position Salary John Producer $10,000 Jeremy Producer $98,000 Jaime Producer $50,000 Darren Artist $67,000 Chris Artist $75,000 Clint Artist $30,000 Adam Artist $57,000 In Cell C2 (salary for John) I want to create a formula that looks for all rows that contain the same position as in B2 (John's position which is producer) and then calculates the average of all the salaries in column C of those rows that have the position producer. Then I want to c...

Is there a formula that I can use in a spreadsheet that can check whether the contents are a value or text. Got a spreadsheet that needs values in a column, but do occasionally get people using ' and " prefix to input values therefore turning contents into text. Cheers all Yes Check out =ISNUMBER() and =ISTEXT() in the help system "Mikeymay" <anonymous@discussions.microsoft.com> wrote in message news:071601c4a222$4557db70$a501280a@phx.gbl... > Is there a formula that I can use in a spreadsheet that > can check whether the contents are a value or text. >...

When Using an =IF(,,) function like =IF(A1="","",A1-A2) if A1 is blank Excel still shows a zero in the graphs even when show blanks as zero option is not selected. Any way to fix this? You could replace your "" with N/A() this is not plotted -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS "Regulator" <Regulator@discussions.microsoft.com> wrote in message news:19A20FA2-81A5-4726-93F0-B61C1DCF49FF@microsoft.com... > When Using an =IF(,,) function like =IF(A1="","",A1...

First, let me apologise for my lack of Excel knowlege. I have tried to teach myself to create this formula on my Excel 2002, however....I give. I humbly ask for someone's help. Column A will be the current date...then there will be 6 columns of data. I need to have a formula which will do the following.... If the value of column E is equal to or less than column E's value from the day before, and the value of Column F is equal to or less than Column E's value from the day before, assign a value of 3 to Column H. If the value of column E is equal to or less than column E...

Hi All I have a spreadsheet with the following A1: z:\data/pc32/tsheets\unsorder00039.csv I would like to add 1 too the number to make unsorder00040.csv and so I have try mid,right,left i can't seem to do it Cheers "Jason" <Jason@discussions.microsoft.com> wrote in message news:53AAB904-8595-499F-BF38-8BE00826101C@microsoft.com... > Hi All > > I have a spreadsheet with the following > A1: z:\data/pc32/tsheets\unsorder00039.csv > > I would like to add 1 too the number to make unsorder00040.csv and so > I have try mid,right,left i can't see...

I would like to use the results of a formula in a cell as an actual number. Any help would be appreciated? Hi copy the cell and use 'Edit - Paste Special - Values' -- Regards Frank Kabel Frankfurt, Germany "Carlton A. Barlow" <CarltonABarlow@discussions.microsoft.com> schrieb im Newsbeitrag news:D8B1F514-E50A-4CB8-98B5-50D6FAA4B739@microsoft.com... > I would like to use the results of a formula in a cell as an actual number. > Any help would be appreciated? An easy way to do this is when editing the formula just type cntl+"=". It immediately chan...

Hi All, Please help me by creating a simple formula to findout the percentage differences of "current month" - "last month" automatically whenever the data is updated. Grade Year Jan Feb Mar Apr May 1 2005 2555 3488 2213 3239 Thanks, Lazia math is (current month)/(prior month) - 1 If current month iis in C2 and prior in B2, then in the cell where you want the % change, type: =C2/B2-1 "Lazia" wrote: > Hi All, Please help me by creating a simple formula to findout the percentage > differences of "current month" - "last mo...

I have a liquor inventory worksheet that I am trying to get to give me an order amount based on pars. I have this: On Hand Liquor is E Par is column B I currently have this as a formula: =IF(E36<B36,24,0) This part works and I order 24. The problem I have is ordering beer. It comes in cases which are 24 to a case. So, I need to order 24, 48, 96 etc. If B36 is >24 but <48 I will have to order 48. If it is >48 but <72 I need to order 72. Can anyone help me with this? Use the CEILING function. -- David Biddulph "Roxie" <Roxie@discussio...

Hi, I am trying to average a range of data that spreads accross many sheet (one cell in each sheet). I am sorry if my explanation is vague onl am struggling to describe the problem butr here goes. =IF(ISERROR(AVERAGE(IF($H$4:$H$18=$H21,$N$4:$N$18))),"",AVERAGE(IF($H$4:$H$18=$H21,$N$4:$N$18))) is a formula which all values in a column which are equal to a value i column H21. The problem I am faced with is that when creating a sheet to averag all the values from each sheet using formula: =SUM('calls closed 3, 4 Dec:Calls closed 15 Dec'!I21)/COUNTA('call closed 3, 4 D...

Hey guys. I was wondering if someone could help me. I am writing a vba script that takes in data, analyzes it, and then copies the results to a new file. I am having a problem with two things. 1) I am using a template for the new file so there are a lot of formulas (sums and std) already defined and ready to use. However, there are some instances where there is a random amount of additional data I have to put in. So, I have to apply the same formulas to this new data. How do I copy formulas from one cell to another (allowing for a change in row) in vba? Lets say cell(1,4) has the form...

e4=1.075 Tax =c10*e4 original formula =c11*e5 (should be e4) =c12*e6 (should be e4) =c13*e7 (should be e4) =c14*e8 (should be e4) =c15*e9 (should be e4) =c16*e10 (should be e4) =c17*e11 (should be e4) =c18*c12 (should be e4) =c19*c13 (should be e4) I need to copy the formula C10*E4 to a hundred rows. I need E4 to stay the same and not Increment to e5,e6.e7.e8 ect. what do I put infront of e4 to stop it from incrementing -- Dennis Gelso On Thu, 8 Apr 2010 18:32:52 +0100, Dennis Gelso <Dennis.Gelso.603da3b@excelbanter.com> wrote: > >e4=1.075 T...

What is the formula that brings back a zero for an empty cell instead of 0 0 #DIV/0! Try =if(iserror(formula),0,formula) ************ Anne Troy www.OfficeArticles.com "Dave" <Dave@discussions.microsoft.com> wrote in message news:8392DE7F-0B65-4DEE-87F4-985133BB1976@microsoft.com... > What is the formula that brings back a zero for an empty cell instead of > 0 0 #DIV/0! > ...

I have a worksheet (named monthly) with a column of data under a certain month (which will change each time data is entered - stocktake). However this column needs to be edited each month and has formula's in it so it will work (not always the same data in the column). I decided to put this data into a yearly sheet under the particular month. The only way I can do it at the moment is to copy and paste special. How do I (or is there a way to) put this data in a sheet that has all the months but under the month that is signified. In other words I don't want formula's in the yearl...

I have a table with 3 column: Sales Rep Cust. # Territory Ron 5001 5 Ron 5002 6 Paul 5003 10 paul 5004 11 I am trying to come up with a formula where in another sheet I have Sales Rep Cust. # Territory Ron 5001 Formula (I have been trying to use index, but nothing worked for me) Any help from somebody. Thanks Fernando, A few options: Setup: On Sheet 1 your table in A1:C5 (data in A2:C5) Sales Rep Cust. # Territory Ron 5001 5 Ron ...

I have a cell that is using an index to pull the owners cost. I would like to add a comment or data validation to that same cell that runs a different formula to show the customers cost. This way I only see the owners cost and by selecting the cell I then see the customers cost Thanks I bet you could do this, but I'd try to make my life a little easier. I'd use another column and just hide/unhide it when necessary. Logan Nalley wrote: > > I have a cell that is using an index to pull the owners cost. I would like to add a comment or data validation to that same cell that ru...

Hello, I am beginner student trying to figure out a formula that calculates how to pay people for the number of hours they work, and at the same time figure out any overtime they may have. The wage is in cell B4, and the # of hours is in cell C4. Overtime is figured at 1.5 of the wage in B4. I must put the end result in F4. The instructor rushed through his presentation, and said to use the "if function". The assignment is due on tuesday and any help with this is greatly appreciated. -Thanks in advance ------------------------------------------------ ~~ Message posted fro...

When I write a formula, that is truly long, I recieve a message "Formul is too long". Is there a way to remove this limitation so that I coul write long formulas? Any help is welcome. kra -- kra ----------------------------------------------------------------------- kras's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2866 View this thread: http://www.excelforum.com/showthread.php?threadid=53407 There is no way (as far as I am aware) of removing the limitation. A work round would be to have two additional columns. Columns A and B should have par...

I'm hoping someone can help me. I have a form where I enter several marks for a student and then a bunch of calculations are made. I want to be able to clear that students marks and enter another students marks. Other than using "save as" and opening and closing the file, is there a way to clear the data, but leave the formulas and formatting intact? You could select the cells where you enter the data and clear those. RIght click and CLEAR CONTENTS. "pingu_632@hotmail.com" wrote: > I'm hoping someone can help me. I have a form where I enter several >...

I am using excell 2007 & this formula works {=IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC5>0,G5:HC5))),0)} When i upload this workbook to a 2003 version this formula does not work I get {=_xinfl.IFERROR(AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC5>0,G5:HC5))),0)} or somthing close to this Then in the cell with this formula has a NAME error WHY & HOW could i fix The IFERROR function can only be used in Excel 2007. Try this array formula** : =LOOKUP(1E100,CHOOSE({1,2},0,AVERAGE(IF(MOD(COLUMN(G5:HC5)-COLUMN(G5),4)=0,IF(G5:HC5>0,G5:HC5)))...