//autoaverage.
Mon, 25 Aug 2008 01:24:02 -0700
Hi !! If i have a table like below :
WEEKS EAST NORTH SOUTH WEST COUNTRY
WK31 10 17 24 31 82
WK32 16 23 30 37 106
WK32 22 29 36 43 130
WK32 28 35 42 49 154
WK32 34 41 48 55 178
WK32 40 47 54 61 202
WK32 46 53 60 67 226
WK32 52 59 66 73 250
WK33 58 65 72 79 274
WK33 64 71 78 85 298
WK33 70 77 84 9 ...
|
Start, Finish including break time
Mon, 25 Aug 2008 00:46:04 -0700
Hi all,
I currently have a excel spreadsheet set up to take the following.
Just an example:
Cell A1 - Time Started (In 24 hour time) - "06:30"
Cell A2 - Break Time (Generally Half an hour) - "00:30"
Cell A3 - Finish Time - "16:30"
Total - =(A3-A2-A1)*24 Which gives me a result in hours which I wanted. "9.5"
...
|
When inserting column I get "cannot shift object off sheet"
Sun, 24 Aug 2008 22:40:01 -0700
When inserting a column in excel I get a message that says "Cannot shift
objects off sheet". ...
|
payback period for a 10 years investment
Sun, 24 Aug 2008 22:02:00 -0700
I need help to set up a table to calculate a payback period of an investment
of $1.0 Million. what are the parameters and assumptions I need to consider ...
|
Automatically Entering Values
Sun, 24 Aug 2008 21:28:01 -0700
Is there any way to preset some values?
Suppose I entered some values in From A1 to A4 (A1=12,A2=13,A3=14,A=15)
Now I want that when I enter 12 in C1, it automatically feels 13 in C2,14 in
C3,15 in C4.
Is that possible?How? ...
|
Question on create chart
Mon, 25 Aug 2008 10:24:50 +0800
Hello:
I would like to have summary of the existing OS in % ratio with Pie
Chart present. May I know how can I create in base on the existing data?
Attached is the sample data sheet.
Thanks!
...
|
Sum
Sun, 24 Aug 2008 19:24:00 -0700
I would like to sum a common cell, by defined name, accross a set of
different sheet. The cell name is the same, with a scope to the sheet only.
Example: sheet1!total + sheet2!total + sheet3!total... and so on
I want to be able to do this without having to type in the above, but have
been unable to de ...
|
|
|
Help with changing a formula
Sun, 24 Aug 2008 18:50:02 -0700
The current formula I have is...
=IF(COUNTBLANK(INDEX(F:L,ROW(),))<COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING
CREDITS","")
I want to make one addition to this formula. Before it does my current
formula I want it to check if any cells in F:L,ROW() are <0, if they are i
want it to be blank, if not then I want ...
|
Simple Formula Help
Mon, 25 Aug 2008 10:49:46 +1000
I am trying to set a simple formula as follows:
H7: Result of Formula
G6: Original Value ($20.69)
G7: New Value ($10.28)
H7 is Formatted to (%).
I want IF G6<>"" or G^<>0 then the Percentage to be Saved in Cell H7, else Nothing to be displayed.
Also, if the New Value (G7) is great ...
|
formula help
Sun, 24 Aug 2008 17:00:02 -0700
I'm a novice Excel user. This is probably basic, but.. whats the proper
formula for this activity?
row 3 - column c is a number - 20 column d is a number - 24 i'm
subtracting d-c. result in h.
sometimes there is a column e with a number. sometimes not. if there is I
am subtracting e-d. result in g. ...
|
