Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / September 2006

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
formulas19 Sep 2006 22:03 GMT4
To you pros out there this may sound stupid.  If taxes are 8.160% what
formula would I use to get the exact amount.  Not sure where to put the
decimal point.
Thanks
How do I sort data?19 Sep 2006 20:47 GMT2
I have a range of data and needed to sort it by more than three types.  When
I go to "data" then "sort" it only gives me three different sort types.  Is
there any other way that I can sort 4 or more types.
Working night and day..... Timesheet19 Sep 2006 20:36 GMT5
In              Out          In             Out          The total time I
get          Overtime
15:00    18:30    19:20    02:00            -13,83           0,00
I'm using this Formula:
How do i add a column of values based on another column in excel19 Sep 2006 20:29 GMT2
I am doing up a minor budget scheme and I am a little stuck on this one.
I have 2 columns.  First column is an amount and the second column has
different they type of amount of the first column.
eg:
Sumif referring to range names formulas not updating19 Sep 2006 20:14 GMT1
I have several sheets rolling into a summary sheet.  The data is by location
and data type.  Using SUMIF referring to range names to get the numbers in
the right place.  My formulas are not updating automatically though automatic
calculation is selected in Options.
Excel formula19 Sep 2006 20:03 GMT1
I am looking for the formula to enter in Excel to populate a cell with the
text description that corresponds to the selected numeric value selected in a
separate cell.
Thanks.
Macro within a function?19 Sep 2006 19:57 GMT1
Is it possible to put a macro inside a formula? For example, can I make the
true value fo an IF function run a macro? If so, how? I can't find it in the
HELP!
HOW CAN I SERIALIZE SHEETS IN EXCEL19 Sep 2006 19:31 GMT1
I am trying to serialize a purchase order form in excel automatically so the
number each time I print it will advance by increments of 1
Excel 2003 SP219 Sep 2006 18:48 GMT3
when formatting cells with negative numbers in currency, drop down box does
not include brackets as option. line 3 option is same as line 1 -$1,234.00  
any suggestions besides re-install
Worksheet Link19 Sep 2006 18:09 GMT1
I built the following formula as instructed in the Help.
    =DSUM(BUD2006.XLS!ACTUAL,23,$A$9:$B12)
When I close the BUD2006 file, the formula changes to the following:
    =DSUM('D:\work\BUD2006.XLS'!ACTUAL,23,$A$9:$B12)
Calculating values from multiplesheets with multiple criteria19 Sep 2006 17:38 GMT19
I'm sure this is simple nut I have no idea!
(Apologies for incorrect terminoligies)
*Background*
My workbook two worksheets of data.
MATCH?19 Sep 2006 17:29 GMT1
I have 10 columns/1 row that have different numbers.  I want the 11th column
to match for a specific number if found.  Here's an example with expected
result
1    2    3    4    X
code help please19 Sep 2006 16:40 GMT2
i am trying to create a simple macro whereby i add in a new person to a
holiday chart which involves adding in some formula lines and so on, but how
do i make sure my macros start copy pasting at the next available line ?
Conditional formula19 Sep 2006 15:55 GMT4
I have a series of data in a two row and need to make a conditional lookup.
The problem is, that a conditional formula is restricted to 7 arguments.
The problem:
I have two rows. In the upper row is a target value for each month and in
date/time calculation needed19 Sep 2006 15:54 GMT2
I'm looking for a simple formula to add 140 hours from a entered data/time.  
Example:  In D6 a date/time is entered.  In E6 140 hours is added giving the
results in a new date/time format.
This is probably simple but having problems making it work.  Also, how would
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.