I have basic fields that are on a data entry form so when the clerk types in quantity and unit price the TOTALS field calculates this. When I look at or pull in the TOTALS field on my report it just shows $0's. How do I get the report to show what's on my form? On Thu, 24 Jan 2008 10:00:37 -0800 (PST), p-rat <osupratt@yahoo.com> wrote: >I have basic fields that are on a data entry form so when the clerk >types in quantity and unit price the TOTALS field calculates this. > >When I look at or pull in the TOTALS field on my report it just shows >$0's. How do I ...

I would like to caluclate MIN and MAX on a column of numbers based on text in another column. For example, the numbers are in column B and column Q has "test failed" or some other text in it or no text at all. I want to include values from column B and calculate the MIN and MAX if column Q has "test failed" in that row and in another cell, calculate MIN and MAX if column Q has anything other than "test failed". Any help you can offer is appreciated. Scott in Ottawa R1: =IF(Q1="test failed",MAX(B:B),"") S1: =IF(Q1="test failed...

Thanks. I'll try out those suggestions. De -- da ----------------------------------------------------------------------- dah's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=649 View this thread: http://www.excelforum.com/showthread.php?threadid=27191 ...

I am using a way to do the following column1 column 2 column 3 (2+3)+(3*5) 5+15 20 in the first column I want to be able to see the expresion in the second column I want to have the result of each parenthesis and in the final column the result Please help Thanks Stelios ...

In an excel sheet, I am typing in a new formula: "=Master!C271". However, instead of showing what is in that cell, it shows the formula. Does anyone know how to fix this? Thanks! Hi Mike tools / options / view - untick formulas or the cell was preformatted as text, use edit / replace - look for: = replace with: = this tends to fix it Cheers JulieD "Mike" <Mike@discussions.microsoft.com> wrote in message news:78BE9332-7E2F-4DB9-8D84-DE485BB6A878@microsoft.com... > In an excel sheet, I am typing in a new formula: "=Master!C271". However, > ins...

I am using excel 07. I would like to know how to setup a formula to calculate credit card apr or a pre done form that i can download. I have been searching but can not find exactly what i am looking for. I would like to enter current balance, apr and have it calculate what the interest is then have it minus payment and then recalculate balance and have it continue for the next month. I am not sure if this is enough information but i hope it is a start. Any information would help. Thanks in advance. Rob Rob wrote: > I am using excel 07. I would like to know how to setup a formula ...

I would like to create a formula that will check to see if there is value in one of two cells, multiply the found value by a value i another cell and return a total. Specifically: Cell B1 Cell B2 CellB3 Either B1 or B2 will contain a value, not both. If B1 has a value, it will be multiplied by the value in B37 and th result displayed in B3. If B2 has a value, it will be multiplied by the value in B38 and th result displayed in B3. Th -- storeman496 ----------------------------------------------------------------------- storeman4966's Profile: http://www.excelforum.com/member.ph...

Hi, I would be grateful for some help from any expert in the group. I have just bought a new MacBook Pro 17 inch. I have run Remove Office several times and tried to install my legitimate copy of MS Office:mac 2004 from disc. Each time I run Remove it tells me that there are files in Preferences. I select Remove and Empty Trash. I have also checked the Preferences folders and removed any Microsoft files manually. I have secure emptied the trash. And this just repeats... Every time I launch the installer it whirrs for a few seconds then quits. No amount of double clicking will r...

Lately, I have been having difficulties getting Excel to update existing formulas. I press F9 to update/calcuate and nothing happens. However, if I go to a particular cell with a formula, hit F2 to edit and simply press the enter key, the formula updates. What gives? Is this some type of virus? Thanks for any feedback. Hi could you post this specific formula? Also does hitting CTRL+ALT+F9 change the value -- Regards Frank Kabel Frankfurt, Germany Kevin wrote: > Lately, I have been having difficulties getting Excel to > update existing formulas. I press F9 to update/calcuat...

On the Payroll Calculator template under tax status, what do the numbers represent? Any suggestions on the template? ...

Hi, I've installed SFO on two machines as per the instructions and all seemed to go well until I tried to get them to "Go Offline". In each case I accepted the default settings in the offline options screen and pressed OK. A download status box came up with the word "Initializing" then nothing happens for a few minutes and eventually I get an error message saying "you do not have sufficient permissions or access rights to perform this action". Everything seems to work fine when I'm online though. Client machines are Win XP/Outlook 2003 and Win 2K/O...

I am new to Publisher, so bear with me.... I am trying to create a booklet using 8 1/2 x 11 paper in positioned in landscape position. I would like to get 2 pages on one piece of paper, but with the text in a portrait position, if that makes sense. Can anyone guide me? Thanks. -- Lauren When you setup your publication as a booklet, the pages are presented in the correct order automatically. The half pages will be portrait. Have you tried to setup a booklet? If you have, what problems are you experiencing? -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.or...

It would be great to have more functionality in the HQ worksheet formula's if you add a supplier and they have a lot of items, but the costs are the same, a lot of time could be saved if you could copy the cost from the standard cost. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in...

could any body tell me if it is possible to create a formula that allows you for example to input a number in worksheet 1 and for that number to automatically appear in worksheet 2? This formula on any sheet would make the cell equal to Sheet 1 A1 =Sheet1!A1 Mike "ollie" wrote: > could any body tell me if it is possible to create a formula that allows you > for example to input a number in worksheet 1 and for that number to > automatically appear in worksheet 2? thankyou so much > This formula on any sheet would make the cell equal to Sheet 1 A1 > > =She...

I have a Spreadsheet that contains a column of dates (birthdays and anniversarys)in the dd/mm/yyyy format. Across row 1 I have the years 2010, 2011, 2012 etc. At the intersection of the two I wish to insert a formula that will calculate the age or the anniversary. I would be grateful for any help. Thanks in advance. See your other post. Regards, Fred "Chris waller" <Chriswaller@discussions.microsoft.com> wrote in message news:0AFDC0A0-1B1B-47DE-AD7B-E77B64E995AB@microsoft.com... >I have a Spreadsheet that contains a column of dates (birthdays and > an...

I am trying to get the end user to enter the year in question and then have the document return values in column A in dd/mmm/yyyy format and column B in Day of week format for all days in that year You would just use something like =DATE(2006,1,ROW()) copied down, but I am not clear where the year number is stored, and when the flip to column B happens. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "RADIOOZ" <RADIOOZ@discussions.microsoft.com> wrote in message news:5A7C3C6F-8AEE-487F-8ADF-62F2234C3858@microsoft.com... > I ...

I am working on a bonus chart and this is what I am trying to do: If an employee keeps his liquid tempatures under 40 degrees the recieve 100 points. If they are higher than 40 degrees they get points. the problem is they have two temperature check per week. I they are over on one of the checks they will not get the 100 points. can I have one formula to check both cells (Both checks) without usin an average between the two temps? I have tried playing with "IF formulas until I am blue in the face. Please help Thanks Mike Manick Longmont, Colorad -- Message posted from http://www.Exc...

Using XL 2000 work 2003 home Need easiest way to formula"ize" the following: Column (A) is the linked-cell value in an XL dropdown box. Column (B) is the value that column (A) needs to be converted to to upload to MS Access. Description (A) (B) Strongly Agree 2 4 Agree 3 3 Disagree 4 2 Strongly Disagree 5 1 No knowledge 6 0 (No Answer) 7 0 Therefore, the selection of "Strongly Agree" causes the linked dropdown box to equal 2 in column (A). I need the (B) value to equal 4 ...

Hello, At your possible convenience, might anyone please kindly answer my question? Thank you very much. I need to calculate composite reliability for constructs (latent variables). I know some people calculate the composite reliability manually. I am wondering whether anyone might happen to know any free software (open resource) that can help calculate composite reliability? Thank you very much. Please take care Caroline Caroline, Post how the manual calc is done, and then we can help. I have no idea what you mean by composite reliability.... HTH, Bernie MS Excel MVP ...

Hallo. I need to set up special pricing for product. For example i sell bananas by 5$, but when they get not look good then I want to sell it by 1$. How to create the pricing mechanism for this situation. Itâ€™s not a special sales price because in the same time I can sell good bananas for a regular price. Ho to resolve that pricing situation in RMS? On May 2, 8:00 am, Martins <Mart...@discussions.microsoft.com> wrote: > Hallo. > > I need to set up special pricing for product. > For example i sell bananas by 5$, but when they get not look good then I > want to se...

How can I get yesterdays date in a custom footer &[DATE]-1 does not work try =today()-1 chuck <chuck@discussions.microsoft.com> wrote in message news:5A51D4C3-07A5-48A8-A594-09F51D4B46A6@microsoft.com... > How can I get yesterdays date in a custom footer &[DATE]-1 does not work Chuck - You will have to manually or programmatically change the displayed date in the footer. There are no page setup codes that will put a different date in a footer. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTe...

Hi, when I go to print an email (in Microsoft Outlook), I press "file", then "print", and usually I get a window asking "Print pages -- "all" or "page numbers.." etc, but I don't always get this screen. Sometimes, (depending on the email), I get "print all pages, print only odd pages, or print only even pages". How can I only print the current page, all the time? Thank you! ...

I would like to reformat 10- and 11-digit the numbers (e.g. like 1,935,674,923 as 1.9B). Can this be done? Custom format: 0.0,,,"B" best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Dave" <Dave@discussions.microsoft.com> wrote in message news:262241F3-063E-4F97-B864-A629EC670112@microsoft.com... > I would like to reformat 10- and 11-digit the numbers (e.g. like > 1,935,674,923 as 1.9B). Can this be done? Dave, Use a custom format of #.#,,,"B" or 0.0,,,"B" depending on ho...

I am trying to calculate monthly INTEREST ONLY payment on a short term bridge/swing loan. Assuming an interest rate of 2.75%, paid monthly, Also assuming it will be required for a 3-6 month period, amount approx $500,000. Just switched to Excel 2007 but don't seem to be able to calculate using the formula builder. Not sure if it is compounded daily or monthly. You might want to check out the IPMT function. From the XL help file: IPMT(rate,per,nper,pv,fv,type) Rate is the interest rate per period. Per is the period for which you want to find the interest and must...

(MS Excel 2000) Hi, Can I type "1" into a cell and get it automatically to come up as a "One" in another cell. Similarly can I type "2" into the same cell to come up as "Two" in the other? ... and if so how? A juicy red apple is nice but not every apple is red! http://www.wattersons.co.uk --- Message posted from http://www.ExcelForum.com/ njhagan, I'm not sure that this is what you want but if you enter : =LOOKUP(A1,{1,2,3,4,5,6,7,8,9,10},{"One","Two","Three","Four","Five","Six",&qu...