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 / December 2005

Tip: Looking for answers? Try searching our database.

ThreadLast Post  Replies
HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT()?27 Dec 2005 15:47 GMT2
HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT() FUNCTION
AS IT IS DISPLAYED IN BHAT FORMAT.
Help with formula IF27 Dec 2005 15:30 GMT1
I have a column that has a simple IF formula. What has happened is this
formual is not working how I need it to. At the end of a day we need to know
how many hours this setting was used. If no number is entered into the cell I
have my If formula showing ther plant hours run for ...
indirect returns #REF! regardless of where it is used.27 Dec 2005 15:28 GMT1
I searched the forums for reasons why the INDIRECT function may return
REF. The only answer I found was that it will return REF id it is
trying to access a closed workbook.
In my case, the INDIRECT returns REF regardless of where it is used.
Formula in Excell27 Dec 2005 15:15 GMT2
I want to refer a value in a table  using a formula where the value will
change according to column heading row heading
Cell Address Matching27 Dec 2005 14:17 GMT1
Please treat this as an urgent message.
I have a worksheet as
5    2    1    3    1    3    1
8    1    2    0    4    6    1
How do I write an Excel formula to calculate my working time?27 Dec 2005 13:48 GMT3
I would like to write a formula where I would input the starting time of a
project or customer call minus the finishing time and then convert that
amount of minutes to tenths of an hour.
Any ideas how?
excel27 Dec 2005 13:35 GMT1
How can I set a worksheet  that has no cell or rows. I need a blank page with
week 1 week 2etc. @ the bottom instead of sheet 1 sheet 2 etc. ?
VLOOKUP show all results27 Dec 2005 07:17 GMT4
hi people i am working on a database. i want to use the vlookup for example..
Names  age  Vlookup john age
john      1              1
bill        2              4
Trouble with formula on Student 2006 learning essentials template27 Dec 2005 07:05 GMT1
I'm having trouble with a formula on Student 2006 software and it comes with
the learning essentials for Microsoft office. It has numerous templates. The
specific template is the Grade Tracker. When I opened up the template to use
and modify there was a formula that was found to ...
Drop down box of names with fixed values?27 Dec 2005 06:15 GMT5
I'm trying to streamline how to determine costs to make a garment easily.  We
have muliple different fabric options, each with its own cost.  
How do I create a drop down box that lists the fabric names and also links
this selection to the cost of the fabric so I can easily see ...
RUNNING TOTAL27 Dec 2005 05:52 GMT7
RETAIL VALUE IN COLUMN A1; SALES TAX IN COLUMN B1; SUBTOTAL IN COLUMN C1; AND
RUNNING TOTAL IN COLUMN D1.
RETAIL VALUE IN COLUMN A2; SALES TAX IN COLUMN B2; SUBTOTAL IN COLUMN C2;
AND RUNNING TOTAL FORMULA IN COLUMN D2 WHICH SAYS:  
How do I highlight a cell using conditional formatting and dates27 Dec 2005 03:56 GMT6
I am using Excel 2003.
I want to use a conditional format to identify by a different color when a
date is 90, 180 and 360 days from todays date.
I have two rows of data.  The top row contains a room number and the bottom
Excel dropdown with text and value27 Dec 2005 03:15 GMT2
Is it possible to create a dropdown in Excel that will act like an HTML
dropdown, meaning that when opening the dropdown we will see, for example,
the texts Red,Green,Yellow, and each one has it's own value, for example:
Red=1
how do I convertext in cells a1, a2, a3 and covert to a1, b1, b227 Dec 2005 03:00 GMT3
I have addresses which were entered in cells a1, A2, A3 and so On and I need
to convert them to appear in cells a1, b2, b3 I know I have performed this
function in the past but I am drawing a blank please help.
calculating return in a range27 Dec 2005 00:49 GMT5
I have a range of stock prices. with indication for buy or sell. and
want a function to calculate the return of the range for example :
buy 522.73
buy 527.9
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread



©2008 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.