| Thread | Last Post | Replies |
|
| fHow to write in a formula "if a nuber s between these two numbers | 30 Sep 2006 14:35 GMT | 11 |
Hi I need to write a formula that chooses from 3 different values and returns the one I want it to. lets say I have 10, 20 & 30 in 3 different cells and the number I want it to look at is 22.
|
| How do I change the date format in Excell from eg 20060926 | 30 Sep 2006 14:22 GMT | 2 |
Excell doesnt recognise the above format as a date, so I would like to change it, however the standard date formats dont work.
|
| DELETE ROWS FROM XLS IF THE ROW CONTAINS THE STRING | 30 Sep 2006 13:21 GMT | 1 |
I wanted a macro , Which would find a particular string in that row and then delete that row. for example in the following example i want to delete all the Rows which contain the String "aaa","syz"......( I have about 500 words).
|
| Goal Seek or Simultaneous equation Help | 30 Sep 2006 13:15 GMT | 1 |
I'm trying to solve for this simultaneous equation, And could use some help.. I think I need a function In Cell D4 (****) to (in this case) bring back the 8.50%, So that it will agree with my cell D9 (the 8.50%).
|
| excel formula | 30 Sep 2006 12:21 GMT | 2 |
i am trying to get a cell to say "week starting (todays date). so i put in the following formula ="week starting"&" "&TODAY() however the result was
|
| Sum within one cell | 30 Sep 2006 10:18 GMT | 1 |
if i want to make sum of numbers which are within one cell how it is possible ? Weather it is possible or not?
|
| entering emails without hyperlink creation | 30 Sep 2006 06:25 GMT | 10 |
I want to enter email addresses in an Excel column without creating hyperlinks. I know how to turn them off in Word, but cannot find the same option in Excel
|
| No text appears in excell | 30 Sep 2006 06:00 GMT | 6 |
When I type in the top box or a cell no text shows up. On one of my forms all the text was actually omited when I opened. What happened?
|
| [$-409]..... | 30 Sep 2006 05:38 GMT | 2 |
hello community can anybody in the community please tell me what is this square bracket with dollar symbol follow with a dash inclusive the number "409" at the front the the custom format.........example:
|
| " + " and " - " together | 30 Sep 2006 05:38 GMT | 3 |
hi community can somebody tell me how i can get the "+" and "-" sign together ? What am I requesting is the "ALT" + "number pad numeric" example, if I want to display the japanese yen symbol, I would need to use
|
| How to do a macro for IF cell b1 is < b3 turn b1 red? | 30 Sep 2006 04:31 GMT | 1 |
I am trying to figure out on excel if Cell B1 is < Cell B2 then I would like to turn B2 cell words or the cell to red. how can this be done?
|
| Alternate printg 2 Wsheets to diff printers w/out reassigning ptr | 30 Sep 2006 02:34 GMT | 1 |
I am trying to alternate the printing of two different worksheets to different printers. While I can designate the different size the each sheet calls for (one time), I have to re-assign the needed printer each time. Am I doing something
|
| how can I make tabs work only in the colums being used? | 30 Sep 2006 01:45 GMT | 2 |
Tabs move from colum to colum to the right. But, it keeps going to right colums. How can I make the tabs move right only until the last colum that I am using, then move to the next row?
|
| Autofilter misses last line | 30 Sep 2006 01:37 GMT | 7 |
I have a 2075 row database that I autofilter by technical area (i.e. Data/Filter/Autofilter on technical area column header). The filter works fine, except no matter what technical area I select from autofilter pulldown, the last row always displays.
|
| Correct FORMULA NEEDED PLEASE | 30 Sep 2006 01:32 GMT | 5 |
I am using the following formula: =SUM(H5:H12,G5:G12,F5:F12)*200000/M5:M12 The formula is giving me the wrong answer. Is this the correct formula? What I am trying to achieve is continuos information for a rolling 12 months. When
|