Dave I could post a macro for changing cell references, but might be easier to use this code copied from someone in these News Groups. Proper...

This formulae pulls from a cell with that lists 6 options. When an option is chosen, I want it to produce a result. It is giving me: #VALUE! The calculation...

Hi try the following for column C =IF(B1="LAND",your_population_calculation,NA()) HTH Frank I am not even sure how to ask this question... I am...

Hi I haven't been working for a while and have forgotten how to hide zeros in a part of a spreadsheet Barry

I'm trying to create a form in Excel which asks the user a series of questions and the answers are scale based (i.e. on a rating level of 1 - 5). There are...

I've been trying to use the date function to format 010103 as 01/01/03 but it is changing the date to 08/29/27. Any ideas?

I frequently have to count a value (constant) in a cell to determine the formula in another column: say {cell A1}=15,16,27 I would need to insert in another...

I am trying to adjust a user inputted time, date and Time Zone to Universal time. Date: C2 Local Time: C3 Time Zone: C4 But the problem is subtracting...

I am a beginner with Excel, and a little lost. When creating a formula, is it possible to use the content of a cell, without creating labels, to refer to the...

I am Trying to create a Weekly Time schedule for my business. I have to deduct a half hour from each shift if more than five hours are worked. i want the...

hi to evereyone i want to make a function that i have in cell a1 a number 5 and each time the week changes, to add to that number the value 1 eg. if at that...

I have a sheet with categories Investment Trust and AIM in col J. I can get the text to change colour along the whole row according to the category with the...

I was transfering data from one spreadsheet to another by copying and pasting. Some of the cells were data and some were formulas. The formula results in...

If I have a worksheet that had a beginning date column and an ending date column. Is there a way to calculate (using a formula) how many actual work days that...

I have a master sheet with all the sales information that my company tracks. I would like to create seperate sheets for each sales rep. I have all their...

How do I get Excel to say aloud the values in a column or row so I can verify my data entry?

I have a large Excel model with est 60 identical sheets=20 (each containing a set of P/L-statement for individual=20 companies.) Each Sheet is named with the...

Hi anyone got any idea on this? I have a vlookup, which is picking up data from another page in the same workbook, I have to F2 and then Enter to make...

I am copying numbers with leading zeros into excel. I then need to import it to access. I am having a hard time getting the numeric value, with the leading...

Hi, Is there a formula I can use that will enable me to subtotal cell amounts in column A (for example) based upon criteria accompanying cells in column...