With my poor vision I have a hard time seeing the structure in a formula I am
writing or modifying. The built-in tools are useful, but I would like an
option to toggle the formula from this:
=IF($B26="","",ROUNDUP(INDEX(Refs!I:I,MATCH($M26,Refs!H:H,0))*K26,0))

I need a formula that will total all the payroll, overtime and training hours
for B and C in the below example:
         A                B          C
1     payroll            15        8

How do I automatically get the font color to change if I have a date that is
over 18 months old.....like I have February 1 2006 I want that to change to
Red because it is over 18 months old.
Thanks

i just wanted to no by entering this into a cell "C3", the following
=IF(B3<=0,"B3 must be integer greater than zero",(A3^B3)/FACT(B3))
FACT (B3) will give you the Factorial of the value in B3.
is this a VBA programme or do i need to write in visual basic for it

I have a user who keeps seeing the ^ symbol in his Excel cells and he wants
to know what it means.
Thanks,
Steve

is there any formula that put the sheet name in the same workbook any column
or row

I have many files that contains cells in which sentences were split in
multiple contiguous cells. As an example, I have "How are" in A1, "you doing"
in A2 and "today?" in A3. I need to merge these 3 cells by keeping the
content of A1, A2 and A3 into A1. There could be a variable ...

I need to copy cells from one worksheet to
another [same workbook], based on two conditions. The conditions are simple,
e.g. ISBLANK($A30) and $C30="OPEN", etc. The original column has 200 entries.
Only 50 of them may be copied in consecutive cells in a column on the new

I am trying to compare data between 2 different worksheets.  I have them both
open (side by side).  Is there any way I can set it up so that when I scroll
in one active window, the other open windows will scroll in sync?

I made some changes to a spread sheet that were wrong and then saved the file
and would like to be able to go back to the previous version of this file.  
Is that possible?

can i print part of a work sheet with grid line and part without grids line

I am struggling with getting a return value of 1 or 0, or true or false from
a cell that conatins text.
I have text in one cell, what i need is to look at that cell, detect either
text or nothing and return the value of true/false, or 0 or 1.

im writing a VBA programme where x = 2 in cell A3 and cell B3 = 5
and in cell C3
=IF(B3<=0,"B3 must be integer greater than zero",(A3^B3)/FACT(B3))
can anyone help me  write a VBA programmeto ensure that x from cell a3

I am using a trial version of excel 2007 in 2 computers. Both are brand new
Dell. In one (the Desktop) everything is OK, but in the notebook at the
moment of closing the document in what I am working,  or going out of excel
always the program find a problem and become ...

I need to copy cells from one worksheet to
another [same workbook], based on two conditions. The conditions are simple,
e.g. ISBLANK($A30) and $C30="OPEN", etc. The original column has 200 entries.
Only 50 of them may be copied in consecutive cells in a column on the new