Hi, In the Community NewsGroups why i am unable to see the updated information. The last question i can see is the one posted on 17th Sep 2003 10.34pm. Till...

Hi Howard, There are several ways to do this depending on how many variables there are. Here's one way: =CHOOSE(A1,400,375,325) Whatever number you enter in...

How can I use @pmt function to calculate monthly payment when first payment is something other than 1 month (ie 45 days). Please e-mail me.

I have a file from the Australian Bureau of Statistics which is in excel, but is ASCII comma delimited. None of the usual excel functions will recognise...

Hello All, I am creating a scheduling workbook with 2 work sheets, the first sheet is the schedule itself and the second is the availability. When a staff...

I have a spreadsheet with 8 years worth of data in col months. For example row5 Col's C through CF have dates starting with the first day of the month, like...

I'm trying to write a formula that will count a cell if it has a certain fill color. For example, I have a range of cells, A1:A3, where A1 & A2 are filled with...

Sorry if this is a stupid question I know its simple for you all. But I want to use tab and return to move from one textbox to another. I would like to choose...

I have a date in cell (eg:1-Jan-2003).I want the next cell to be date 3 calendar months away(1-April-2003).How do I do this using a formula? satish

I have a result that needs to be rounded up such as 60.2 should become 61 When I format cells to whole number it rounds down. I need to round up in all...

I have selected all worksheets in a workbook to print. Now I can't get the option off. I do not want to always print this way. Help!!

I am working with a model in which I am converting to a current scenerio. When I go into a specific cell to change the link it gives me a error that reads "No...

I need to draw the graph of tan x, which involves the use of infinity. Can anyone tell me either how to display the infinity sign or alternatively how to...

I have a workbook with 4 worksheets. The first worksheet is to be a summary sheet that shows the status of a line item as it moves through various stages. The...

Hi: I have many records arrayed horizontally. I have a list of symbols in column E, a list of dates in column G, and a "Yes" or "No" for each record in...

Hello, I am having troubling making sense of creating if than statements to work for my formulas in excel. Is there a better guide than the one provided in...

I use excel to do quotes for my customers. I have about 100 or more masters. If I am to busy or not here someone else will do the quotes for me. My problem...

Hi I don't know what's happening - I posted the request below yesteday, a few people very kindly replied with some very good ideas - when I went back inbto...

I have a worksheet in which I keep information about students (i.e., name, grade, disability, birthdate, evaluation date). Every 3 years each student must be...

I work for a major theatre chain an no one (inclduing the help desk) can figure out how to make a show start/end time schedule calculate the ending time. ...