I am trying to write a wine spreadsheet and would like to have one column
that indicates the year the wine is ready to drink.
I have entries about using TODAY() to indicate dates before the current
date, however I am struggling to get it to recognise the conditions when the

Please help...
I am trying to create a formula that captures a certain cell's value IF it
is equal to or lower than 0 (zero).  I am also trying to reverse this formula
for another section.

Is there any way in Excel to get a formula to covert to a value after the
first time it calculates? I have a column that calcuates whether or not a
budget has been overspent after each bill is paid against it:
=if(b22<0,"YES","NO"). For the sake of historical data it would be ...

I am having trouble creating a validation rule for cells.  I would like only
6 digit numbers to be entered.  However, when using CUSTOM (000000) I can't
seem to get it to work.  Any thoughts?
012345

Trying to use the AND function in an array but the response is always FALSE.
Looking for responses between yesterday and 21 days ago.
Equation: AND($E40:$E50<TODAY(),$E40:$E50>TODAY()-21)
I am selecting a range of cells F40:F50 before entering in the above

I have simple functions in my workseet - e.g. summing 3 cells to get a total.
When I change the value of one of the cells, the total does not change.  I
cannot figure out why.

I'm aware of the function DEC2BIN(), but it has a limitation of 10 bits.
Are there any 16 bits solutions available?

I need to graph information that is based on a ranked table. A vlookup
function finds information based on ranks 1-15 from one column, however when
the data is the same Excel assigns duplicate ranks. This then does not allow
an average or trend line to be calculated accurately, ...

Is there a way to extract (copy) a particular portion of a cell's contents
where the cell's number format is dd:hh:mm?
For instance, 04:09:12 indicates 4 days, 9 hours and 12 minutes.  I would
like to extract the days, hours, and minutes separately and copy them to

When the user enters a number in cell A1, I want cell B1 to divide that
number by 8.  If A1 is blank then B1 should be blank.
Alternately, when the user enters a number in cell B1, I want cell A1 to
MULTIPLY that number by 8.  If B1 is blank then A1 should be blank.

Is there a way to preven Excel from removing a formula in a cell when just
clearing what is being displayed?
For example:
I have =IF(ISERROR(SUM(AG3+$AL$3-AH3)),"",SUM(AG3+$AL$3-AH3)) in a cell. The

I am trying to use VLOOKUP for both columns A&B and I get the "#value!"
error in the cell with the formula.  This is the formula I am using:
=VLOOKUP(A1:B1,table_array,3,false)  If I use just column A:
=VLOOKUP(A1,table_array,3,false) it works but I get 0.14 as the result.  How

I have the following info on one tab:
Date          Acct         Amt
1/31/2006    100200    1,000.00
1/31/2006    101000    -1,891,715.85

I have seen several similar questions posted and none of the resolutions seem
to be working for me.  I hope Microsoft addresses this issue in the upcoming
Office release.
I have a worksheet that uses VLOOKUP to match a name to names in other

Hi need help with the following I've a cell with a value of between 3 &
11, I need to see if that cell meets a criteria to rate accordingly.
between 3 & 5 = 8 points
between 6 & 10 = 9 points