| Thread | Last Post | Replies |
|
| HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT()? | 27 Dec 2005 15:47 GMT | 2 |
HOW TO DISPLAY NUMBER INTO ENGLISH USING BAHTTEXT() FUNCTION AS IT IS DISPLAYED IN BHAT FORMAT.
|
| Help with formula IF | 27 Dec 2005 15:30 GMT | 1 |
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 GMT | 1 |
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 Excell | 27 Dec 2005 15:15 GMT | 2 |
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 Matching | 27 Dec 2005 14:17 GMT | 1 |
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 GMT | 3 |
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?
|
| excel | 27 Dec 2005 13:35 GMT | 1 |
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 results | 27 Dec 2005 07:17 GMT | 4 |
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 template | 27 Dec 2005 07:05 GMT | 1 |
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 GMT | 5 |
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 TOTAL | 27 Dec 2005 05:52 GMT | 7 |
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 dates | 27 Dec 2005 03:56 GMT | 6 |
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 value | 27 Dec 2005 03:15 GMT | 2 |
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, b2 | 27 Dec 2005 03:00 GMT | 3 |
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 range | 27 Dec 2005 00:49 GMT | 5 |
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
|