a when of

1 posts
• Page **1** of **1**

- jobs
- sharepoint
- BizTalk
- Win32 Programming
- JAVA
- Windows 98
- Windows XP
- VC
- MS Office Access
- Microsoft Project

- 1. 3-d reference not adjusting when using Fill Handle to copy down

I am trying to copy a 3-d reference from a cell to others below it using the fill handle. According to the book I'm referencing, the formula should copy and adjust automatically. But when I drag the fill handle, the formula is not adjust. Example: Cell A1: ='Section 1'!B22 If I click the fill handle from A1 to C1 I would expect the values: Cell b1: ='Section 2'!B22 Cell c1: ='Section 3'!B22 Thanks, Gall - 2. excel template for calculating trial balances and adjusting en

this does work as tested,, very nice and compact, thanks alot for your help "Jack Schitt" wrote: > Perhaps try, in F9 > =ROUND(MAX(0,B9-C9+D9-E9),0) > and in G9 > =-ROUND(MIN(0,B9-C9+D9-E9),0) > then if you do not want zeros to be displayed, use custom number format to > suppress zeros or surround teh whole formula with an IF statement that > returns "" if it evaluates to zero (I prefer the former method). I recommend > using the ROUND function as above as sometimes a simple addition that should > return an integer result can, because of the finite capacity of the > processor, give rise to a rounding error in around the 15th decimal place > and so will not test accurately for zero if left unrounded. > > "yesterdaytoday11" < XXXX@XXXXX.COM > wrote in > message news: XXXX@XXXXX.COM ... > > columns B and C are the trial balance numbers (debits and > credits)(sometimes > > blank) columns D and E are adjusting entries (always positive)(debits, > > credits) > > columns F and G should return correct value and should hold the formula's. > > I have been trying with : > > > =IF(ISBLANK(B9:E9),"",IF(AND(B9>=C9,D9>=E9),B9+D9,IF(AND(B9>C9,E9>D9),B9-E9, > IF(AND(C9>B9,D9>C9),D9-C9,"")))) > > > > but maybe it could be shorter? > > > - 3. I have been looking for Pivot table for NCAA Basketball 2004-2005.

Trying to make up a pivot table for NCAA Basketball yearly DIV I schedule. Any suggestions where I might find this? - 4. example if IF(ISNA()) function

Hi Please could someone assist. I have a formular: =IF((E34="Not Done"),NOW()-C34,"") which works but I am trying to return a "" value when "Not done" is not displayed. I have tried using =IF(isna((E35="Not Done"),NOW()-C35,""),"",((E35="Not Done"),NOW()-C35,"")) but this is not working. Thks Gus - 5. control keys

Hi, I have a machine that the control keys don't seem to work on. When you highlight and press control c, the cell fills with a c. Other functions are not working also. When you grab a cell by the bottom right corner and press control or shift, the correct operation doesn't work. help peter

1.Serious help needed for this project Can anyone help me with this

I have a w/s that compares forecasts and actuals. Column A is Month: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov Dec. Column B is the Planned Forecast in $ for each month. Column C is the Actual Amt in $ that was spent for that month I need 3 formulas that at the end of each column do the following: 1) YTD total for each - this formula would take the $ amount for each month and * by the number of days in that month then divide by the actual number of toal days YTD so far. We are a month behind so we would only use through July not include August yet. In other words it is not to date (system date). 2) Forecast total - $ amt for each month * # of days in the month divided by 365 days for the entire year. 3) Sum for the year (got this one figured out). for Actual Totals: Same as for forecast for YTD. The second formula is my problem: for Actual $ amt MTD Forecast. Take the $ amt for each month *the # of days in that month PLUS include the $amt for the forecast months that we have NOT gotten to yet this year. We are done with July, so you would only include Planned/Forecast $ for Aug, Sept, Oct, Nov, Dec taken from that column and sub for actual $ until we can replace it with the info when it comes in. This total is under Actual/Forecast. The last one for Actuals is sum and I got that one. 3) Total - got this one - it is the actual sum YTD. EXAMPLE Month Forecast Actual Jan 91.21 51.75 Feb 82.39 109.31 Mar 91.21 159.24 Apr 88.27 69.86 May 91.21 51.92 Jun 89.69 53.76 Jul 92.73 51.20 Aug 92.73 Sep 89.73 Oct 93.25 Nov 90.26 Dec 104.22 _______________________________ YTD 89.64 77.86 Forecast 91.50 84.67 Total 1096.90 547.05 Jannie

2.Serious help needed for this project Can anyone help me with t

Is the data in column A actual dates, with cell format of "mmm": I have assumed they are dates so "Jan" would be 01/01/2007, "Feb" 01/02/07 (UK format!) "Value" indicates a data mismatch and the dates most likely candidate. Did the days of the month work OK in column D? I tested my solution on your data and got identical results. If you still have problems post w/book to: toppers <at> NOSPAMjohntopley.fsnet.co.uk Remove NOSPAM "Jannie worksheet function" wrote: > I understand what you are saying here to do but I copy and paste the formulas > but I get a !Value error. > > "Jannie worksheet function" wrote: > > > I have a w/s that compares forecasts and actuals. > > Column A is Month: Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov Dec. > > Column B is the Planned Forecast in $ for each month. > > Column C is the Actual Amt in $ that was spent for that month > > > > I need 3 formulas that at the end of each column do the following: > > > > 1) YTD total for each - this formula would take the $ amount for each month > > and * by the number of days in that month then divide by the actual number of > > toal days YTD so far. We are a month behind so we would only use through July > > not include August yet. In other words it is not to date (system date). > > > > 2) Forecast total - $ amt for each month * # of days in the month divided > > by 365 days for the entire year. > > > > 3) Sum for the year (got this one figured out). > > > > for Actual Totals: > > > > Same as for forecast for YTD. > > > > The second formula is my problem: for Actual $ amt MTD Forecast. Take the $ > > amt for each month *the # of days in that month PLUS include the $amt for > > the forecast months that we have NOT gotten to yet this year. We are done > > with July, so you would only include Planned/Forecast $ for Aug, Sept, Oct, > > Nov, Dec taken from that column and sub for actual $ until we can replace it > > with the info when it comes in. This total is under Actual/Forecast. > > > > The last one for Actuals is sum and I got that one. > > > > 3) Total - got this one - it is the actual sum YTD. > > EXAMPLE > > Month Forecast Actual > > Jan 91.21 51.75 > > Feb 82.39 109.31 > > Mar 91.21 159.24 > > Apr 88.27 69.86 > > May 91.21 51.92 > > Jun 89.69 53.76 > > Jul 92.73 51.20 > > Aug 92.73 > > Sep 89.73 > > Oct 93.25 > > Nov 90.26 > > Dec 104.22 > > _______________________________ > > YTD 89.64 77.86 > > Forecast 91.50 84.67 > > Total 1096.90 547.05 > > > > Jannie > > > > > >

3.Does anyone have a template for creating a slip chart in Excel

4.Anyone have a template for a flying club?

I am trying to make a spreadsheet for my flying club.

5.Does anyone have a chore list template?

I am looking for a chore list template. Does anyone know where I can find one.

6. Anyone have a livestock inventory template?

1 posts
• Page **1** of **1**

Users browsing this forum: No registered users and 95 guest