Microsoft Excel Worksheet Functions

Post thread
G
Split one cell in the middle and fill each with one color
  • Guest
Replies
7
Views
79K
ShawnP
ShawnP
G
DSUM - non contiguous criteria range
  • Guest
Replies
9
Views
5K
ariadie
A
S
Calc days between two dates and exclude leap year days
  • scoz
Replies
6
Views
8K
annei
A
G
logarithms back to numbers in Excel?
  • Guest
Replies
8
Views
28K
Rayhna
R
A
Can Excel trigger Outlook reminder?
  • Andee39
Replies
10
Views
13K
npasari
N
D
How do i calculate Standard Deviation on Negative Numbers Only
  • daapower
Replies
3
Views
12K
vvc
V
W
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR??
  • wstsquad
Replies
0
Views
572
wstsquad
W
P
Set non-continuous PrintArea via Function / Name
  • Philipbrown77
Replies
0
Views
462
Philipbrown77
P
E
Is there a Subtract If function
  • Eric
Replies
3
Views
32K
MDHUM
M
L
How do I get Excel to display which financial year a date is in?
  • LemLems
Replies
6
Views
26K
PRITESH PARMAR
P
G
Is it possible to use Excel's SLOPE function on a non-continuous r
  • Guest
Replies
4
Views
10K
NMAN
N
M
Keyboard Shortcut to reach "Name Box" in Excel
  • mehul.hathi
Replies
4
Views
7K
zopfan
Z
N
Need (Excel) formula to make Mark sheet with Automatic Grading
  • Need Formula for Mark Sheet
Replies
15
Views
51K
Bibek Shrestha
B
R
Stop automatically changing value in =RAND or =RANDBETWEEN
  • RAND
Replies
10
Views
101K
arslanu2
arslanu2
J
excel 2003: how do I fix: "Style 'Comma' not found"
  • jrp9206
Replies
4
Views
19K
1945huda
1
G
Using results of VLOOKUP in another formula
  • Guest
Replies
6
Views
9K
Joshuavdh
J
M
Never save Sheet1 of my workbook. Or some other solution to my problem?
  • Marvin Hlavac
Replies
5
Views
900
omar88
O
D
Add criteria to sumproduct Greater than or equal to
  • Diddy
Replies
6
Views
3K
Amin Sabbagh
A
P
Link Password Protected Worksheets to Master
  • PolQueen
Replies
3
Views
879
nette
N
S
Calculating Phone Bills Help Please
  • Sh0t2bts
Replies
4
Views
3K
Mannypros
M
G
Why do my rows automatically hide in Excel?
  • Guest
Replies
3
Views
13K
Tosh G
T
G
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER.
  • Guest
Replies
8
Views
12K
Judge Spread(sheet)
J
G
Pull last word from a text string in Excel
  • Guest
Replies
9
Views
11K
Micky Avidan
M
M
Need VLOOKUP to Work Two Ways
  • MuseCO
Replies
0
Views
1K
MuseCO
M
S
Excel is not copying my formulas correctly when I drag them down
  • SV
Replies
6
Views
46K
cecil.lambino
C
M
Daily Time Sheets with Rounding
  • MIkeC
Replies
1
Views
1K
MIkeC
M
C
Adding up total hours worked on employee schedule using various criteria
  • CGF2704
Replies
0
Views
1K
CGF2704
C
A
Cannot get previous data after ctrl + w
  • AmythSyngh
Replies
0
Views
1K
AmythSyngh
A
G
How can you convert the false/true into 1/0 in Excel?
  • Guest
Replies
4
Views
42K
Dr John Medhurst
D
J
Excel doesn't print the background fill color chosen for a cell
  • Joe Palazzo
Replies
5
Views
43K
Anni
A
P
IF AND Nested Functions - Formula Not Working
  • Pickles
Replies
0
Views
950
Pickles
P
L
Sliding scale for Mark Up
  • Larry Holmes
Replies
0
Views
1K
Larry Holmes
L
G
Workday function linked in an argument of If formula.
  • Guest
Replies
14
Views
2K
tiger7ail
T
G
Return next non-Blank Cell in a Column ?
  • Guest
Replies
4
Views
24K
v_night
V
G
IF Function Multiple logical tests - Syntax
  • Guest
Replies
10
Views
5K
JAYSON
J
P
Help with logical function
  • PT
Replies
3
Views
1K
Brendan77
B
G
How to UNCONCATENATE cell values
  • Guest
Replies
6
Views
111K
Mac123
M
G
excel: count uppercase letters in a cell
  • Guest
Replies
14
Views
22K
Aabid khan
A
M
Using Excel to calculate future dates with various intervals
  • MH
Replies
8
Views
34K
aldrin
A
J
how do you force a new line in a formula in Excel?
  • JeffRI
Replies
6
Views
168K
Andy Spry
A
S
How to make "countif" on a filtered excel-list? i.e. like subtotal
  • Stiggy
Replies
4
Views
40K
Mark Powell
M
N
Scroll lock is stuck and won't turn off
  • nikole
Replies
6
Views
38K
walldoo99
W
T
Collapsing all groups
  • TW792
Replies
0
Views
1K
TW792
T
E
IF formula for currency or Macro help.
  • EOP
Replies
0
Views
1K
EOP
E
A
How to get text which is inside the brackets in excel sheet
  • arun
Replies
3
Views
2K
Jessica McGrath
J
A
Excel functions
  • Ahmad Reshad
Replies
0
Views
1K
Ahmad Reshad
A
P
multiple logical tests in an IF function
  • Priscilla
Replies
8
Views
142K
TSHEGO
T
G
  • Locked
How can I get Excel to find the first number in a list greater tha
  • Guest
Replies
7
Views
21K
John Bigbootee
J
M
Using text as data?
  • Maza128
Replies
0
Views
1K
Maza128
M
G
How do I do a Reverse Find/Search in Excel?
  • Guest
Replies
3
Views
18K
justincase
J
Top