|
|
! by
mynixo
Do anybody know the formular: "H30 - sum!z19"
|
|
1 |
504 |
|
|
!!! okay. copying formulas!! by
mike KBR
this is drvng me crazy! :) okay...thanks to roger for
helping on "vlookup" .now..i have a lists of plants with
costs ..I was hoping to be able to copy the...
|
February 10th, 2004 08:00 PM
by
|
2 |
550 |
|
|
!REF problems by
Donald Bucci
If I wish to rearrange columns in a worksheet (Sheet A)
that contains cells to which another worksheet (Sheet B)
makes reference, isn't there a convention of...
|
|
3 |
512 |
|
|
|
|
0 |
485 |
|
|
" " by
Easydoesit
What do the empty set of quotes mean in some of the functions and formulas
described here?
|
June 19th, 2005 11:15 PM
by JMB
|
4 |
500 |
|
|
"*" by
Fernando Duran
I have VLOOKUP function, because I have some codes, that I used for
differents rates... so, if I pick-up 96714, I get code rate 124 if I
add an * (96714*) i...
|
April 13th, 2004 11:27 PM
by os-9
|
3 |
573 |
|
|
"--" operator in a formula by
Arla M
I tried looking under Excel's help, but it did not produce any results.
In another question, I was given a SUMPRODUCT formula which had "--" those
2...
|
February 8th, 2005 09:24 AM
by Max
|
2 |
577 |
|
|
"and" "or" in formulas by
donman1950
I'm trying to write a formula to calculate the price of an item as
follows:
=if(+b17=0) and or (+c17=0)," ",+c17/b17)
thanks for your help
---
Message...
|
|
1 |
590 |
|
|
"Average If Not Blank" Formula by
CindyA
I have 10 columns and 5 rows of cells. All cells do not
contain a number and the cells which DO contain numbers
are sometimes 1, 2, or 3 digits. I need to...
( 1 2)
|
May 4th, 2004 06:44 PM
by CindyA
|
11 |
1,145 |
|
|
"Average" function query by
Robin Blackwell
Hi all,
I have an Excel function query that's really bugging me. In column "A" I
have about 80 staff annual salaries. In column "B" I have their
corresponding...
|
|
3 |
620 |
|
|
|
|
0 |
452 |
|
|
"Between" Formula by
Paul
HELP!
I'm trying to create a formula that displays a variable
(5, 7, 8, etc) when the value cell in question lies
between two constants...?!
A simple example...
|
|
3 |
539 |
|
|
"BLANK" - need to delete by
anjgoss
when using a pivot - the word "BLANK" transfers in when the data sheet
has a blank area...
How can I get that to be just blank so that I can use that cell in...
|
August 25th, 2005 05:31 PM
by anjgoss
|
3 |
627 |
|
|
"BLINK" by
Ray
newbie question;
Payroll in excell, is there a way to make a specific cell
containing a date "blink" or flash?
Any help would be appreciated.
Ray
|
|
5 |
602 |
|
|
"Cannot empty Clipboard" by
tiff
When attempting copy/paste, a message pops up that reads "Microsoft cannot
empty clipboard." However, my clipboard is empty. This is preventing me...
|
October 10th, 2005 10:18 PM
by tiff
|
0 |
451 |
|
|
"cascading" formula by
Kathy A
I am summing a row of cells to calculate return mail over
a range of days. Each day's outgo number is multiplied by
a different return rate (this is...
|
|
1 |
431 |
|
|
"Check Boxes" by
John
I have check boxes in my spread sheet. Is there a way
that you can tab to that cell and make a check mark
without having to use the mouse?
|
May 12th, 2004 07:05 PM
by John
|
2 |
469 |
|
|
"colorif" function by
Dave
Does anyone have a macro that works as a "colorif"
function would? For example, color cell green if = 4,
color cell yellow if = 3, color cell red if = 2.
|
|
1 |
509 |
|
|
"Conditional formatting" via VB? by
Trista
I created a workbook which uses about 3000 cells that have
conditional formatting.
Basically, the cell uses a dropdown and if "A" is chosen,
the cell turns...
|
August 3rd, 2004 10:43 PM
by Trista
|
2 |
537 |
|
|
"Contains" in conditional formatting by
Mark
Is there a way to set conditional formatting to respond when a cell contains the text "msg" somewhere in the body of text in that cell?
|
|
2 |
461 |