I have a goal to save $50,000.00 in eight years. My annual interest rate is 6.35%. What amount would I need to put away monthly, to obtain this goal? How would...

I copied a formula from another workbook and now whenever I open the recieving workbook, it asks if I want to update links or whatever, i did the edit find and...

Dear At this forumla " =ROUND(IF($I2="N",$F2*2,($F2*2)-$O2),2)" . I want the result as below. 1. Result = + is ok 2. Result = - show "o" Please advice how to...

Is there a way to connect direct to the newsgroup below via OE6: microsoft.public.excel.worksheetfunctions It doesn't appear in the newsgroups' list...

Hi, I am a teacher and trying to finally get rid off the dreaded mark/attendance book by moving my recording proceedure to Excel. I really really want to be...

I need to keep a bank balance with a current balance (column H) and a running balance (column K) for those posted on bank statement. If posted, cell (column I)...

I've got an existing worksheet with over a 100 names. At some point they were converted to local names. Now I want to add a new worksheet and use those names,...

Trying to match the first six characters of a text string to text characters in a data table. I'm trying to use the VLOOKUP Function, but I keep getting the...

I am trying to make the following formula work and am going nuts trying to make it work - I even called Microsoft and they couldn't do it either? Here is what...

this thing ahs been bugging me for quite some time . Hope that someone can help me! i tried to use sumproduct to calculate the sum of a product based on...

This is hard to explain...but I have a drop down list in a worksheet. Whatever name is chosen in the drop down list I need to show up in a different sheet in a...

Hi, can someone please help. I have employees data regarding hours worked in a decimal format but need to convert this to show hh:mm. So that 3.5 becomes...

Seems to me that there is no easy way of entering calculus style equations into Excel and I just think it would be such a cool tool for students and pure...

I have an existing worksheet with over 50,000 rows and 15 columns. Several columns have information in all uppercase. I need to convert these words into...

In my worksheet, I have to total several groups of numbers. I select the sum function icon and highlight the field. All worked fine except one, which instead...

I have a long list of numbers and I would like Excel to report to me the first number in the list (and not any other) that is greater than a specific value,...

I need to average a bunch of non-adjacent cells as follows: =AVERAGE(B2,D2,F2,H2,J2,L2,N2,P2,R2,T2,V2,X2,Z2,AB2,AD2,AF2,AH2,AJ2,AL2,AN2,AP2) My problem is...

If I have a speadsheet with my employees birthdays listed in a cell, can I make Excel send an e-mail to me, on the date listed in the cell, to remind me my...

When I right click my mouse I get a long menu list on a popup which shows next to the the current active cell. There are too many items on this popup. Is...

Suppose I have a spreadsheet that performs a complicated calculation, involving LOOKUP functions, and other structures that are not easily expressed in a...