|
|
hOW TO USE eXCEL FUNCTION by
SHIV JHA
=IF(AND(M26=7501,N26="A"),M26*G12,IF(AND(M26=7500,N26="B"),M26*F12),IF(AND(M26=7500,N26="C"),M26*E12),0)
SO THAT I AM ABLE TO UNDERSTAND IF SALARY OF...
|
|
2 |
435 |
|
|
Hide used names in drop downbox. by
Robb27
I found something I would like for my workbook. I found it on MVP Debra
Dalgleish's page http://www.contextures.com/xlDataVal03.html. The original
code is from...
( 1 2)
|
April 24th, 2006 12:24 PM
by Robb27
|
13 |
435 |
|
|
|
|
12 |
434 |
|
|
|
May 21st, 2004 03:00 PM
by Andy B
|
1 |
434 |
|
|
Copy cell - fill all blank - multiple range by
Copy Dave
In excel 2002, when i select a cell with blank cells beneath and rest the mouse pointer in the bottom left corner so it changes to a + sign by double clicking...
|
|
1 |
434 |
|
|
# of Functions per cell by
SUB-ZERO
Hi
Is there any way to change the number of functions allowed in each cell?
I have a spreadsheet and I need it to handle more functions than 7.
10-15...
|
|
3 |
434 |
|
|
roundoff when converting text to numbers by
Jack
Can anyone help? When I am converting text to numbers in excel, occasionally
some numbers will roundoff, especially if I am converting a number of cells
at...
|
January 30th, 2005 01:51 AM
by JulieD
|
3 |
434 |
|
|
Why do some Excel cells refer to e-mail? by
Fred in Keswick
Why do some Excel cells display fonts of a different colors. Specificaly,
when I use a sum function, the result appears sometimes in in blue, somtimes
in...
|
February 28th, 2006 10:09 PM
by Elkar
|
1 |
434 |
|
|
|
|
1 |
434 |
|
|
Copying Cells without changing data by
That's Confidential
I currently have a number of cells which contain some functions, referring
to specific cells. As these fall onto a new page, I want to copy these cells
and...
|
|
4 |
434 |
|
|
|
March 1st, 2004 09:20 PM
by John
|
2 |
434 |
|
|
"Microsoft" Patch Virus Messages by
Alan
Does anyone know if the flurry of these things appearing in the newsgroups
recently is due to people maliciously sending them, or if the virus is
sending...
|
|
5 |
434 |
|
|
|
|
4 |
434 |
|
|
|
|
1 |
434 |
|
|
|
|
1 |
434 |
|
|
auto filter macro by
I want to use auto filter or some other device to hide
those rows whose first column has a zero in it. I would
like to come up with a macro that automatically...
|
|
4 |
434 |
|
|
|
January 6th, 2004 05:40 PM
by Gray
|
2 |
434 |
|
|
|
October 2nd, 2003 03:08 AM
by eusgfo
|
8 |
433 |
|
|
Update cell with change date by
Andrew
I have a sheet where I store prices. Is there a way to
return the date I changed a given cell in another cell?
e.g. If I update the info in cell A2, how do I...
|
February 15th, 2004 04:23 AM
by JMay
|
4 |
433 |
|
|
|
|
3 |
433 |