Microsoft Excel Worksheet Functions

B
How to avoid dozen of nested IFs
  • Boris
Replies
5
Views
114K
Harlan Grove
H
P
"Next Year" function
  • Philip Carey
Replies
2
Views
38K
Randall Roberts
R
M
Function:formula is displayed, not results
  • Malcolm Graham
Replies
4
Views
120K
Malcolm Graham
M
J
If Question
  • Jonathan Zingman
Replies
4
Views
146K
Bob Phillips
B
B
Formulas appear as text
  • Bob
Replies
2
Views
123K
RagDyer
R
G
Resizing a Check box
  • Guest
Replies
1
Views
263K
JE McGimpsey
J
P
Salutation Column in Excel Spreadsheet
  • Pam
Replies
1
Views
251K
Guest
G
J
random or blind study
  • JanaLW
Replies
2
Views
48K
JE McGimpsey
J
M
Military Time Subtraction
  • MWB
Replies
5
Views
153K
MWB
M
H
=IF(AND(G48>10,H48>200),OR(H48>400),G48,0)
  • holly
Replies
5
Views
59K
Guest
G
G
Standard Error function
  • Guest
Replies
5
Views
91K
Bernie Deitrick
B
G
Lookup with multiple results
  • Guest
Replies
15
Views
776K
RagDyer
R
N
Response
  • NEW USER
Replies
1
Views
33K
Frank Kabel
F
J
VLOOKUP Problem
  • Jim Rowley
Replies
2
Views
66K
Max
M
G
excel issue
  • Guest
Replies
1
Views
67K
Jonathan Rynd
J
1
Excel column headers
  • 1234
Replies
1
Views
81K
Andy B
A
W
Locking a single sheet
  • Wayne Burritt
Replies
1
Views
25K
Jason Morin
J
D
What have I done!
  • DaveMoore
Replies
1
Views
13K
Chip Pearson
C
W
Counting a number up when a worksheet is opened
  • Wendy
Replies
5
Views
22K
Frank Kabel
F
N
=DATE(LEFT(E5)+2000,1,RIGHT(E5,3))
  • NEW USER
Replies
1
Views
53K
Jason Morin
J
P
How to reference cells in another workbook?
  • path
Replies
1
Views
81K
Frank Kabel
F
R
Combining/consolidating arrays onto a separate sheet
  • rbrychckn
Replies
1
Views
86K
rbrychckn
R
G
Min value and IF
  • Guest
Replies
1
Views
55K
Frank Kabel
F
M
propagating drop down with reference to other cells
  • mark
Replies
2
Views
34K
Bob Phillips
B
S
array formula not working
  • Scruff57
Replies
12
Views
451K
Guest
G
G
referencing formulas
  • Guest
Replies
2
Views
120K
Guest
G
C
Adding and deleting worksheets
  • ChuckM
Replies
1
Views
55K
Andy Wiggins
A
G
Saving Feature
  • Guest
Replies
1
Views
44K
Andy Wiggins
A
N
Row and Cell Summarisation
  • Nza
Replies
1
Views
25K
Frank Kabel
F
H
Using "INDEX/MATCH" to reference an existing external workbook to return Item# description and price
  • HuffieVA
Replies
2
Views
271K
Randall Roberts
R
R
=> VB Command button to Execute Excel Macro
  • Rhonda Fischer
Replies
1
Views
97K
Bob Phillips
B
L
SUM Problem
  • LD
Replies
2
Views
57K
LD
L
G
Matching date's in two different columns
  • Guest
Replies
1
Views
93K
Frank Kabel
F
G
summing a single cell across multiple worksheets
  • gr8guy
Replies
1
Views
148K
Aladin Akyurek
A
B
dates formula
  • barachiel
Replies
6
Views
69K
Norman Harker
N
S
counting distinct numbers
  • Smudger
Replies
2
Views
107K
JMay
J
G
Calculating ages
  • Guest
Replies
5
Views
191K
Norman Harker
N
G
Rate of Return
  • Guest
Replies
12
Views
160K
Guest
G
C
Deleting Duplicates from a File
  • Connie
Replies
6
Views
250K
Grateful Connie
G
C
Adding up times Also converting to Decimal
  • Charles
Replies
4
Views
114K
Frank Kabel
F
S
Counting Cells dependant on data
  • skyshadow
Replies
5
Views
124K
Frank Kabel
F
J
graph a piecewise function
  • Jason
Replies
2
Views
2M
Frank Kabel
F
F
SUMIF > Criteria in another Cell
  • Frank & Pam Hayes
Replies
4
Views
303K
Relix
R
P
Track changes
  • Patricia
Replies
1
Views
85K
Gord Dibben
G
E
Formulas for Times
  • Eleanor
Replies
7
Views
163K
JE McGimpsey
J
G
errors in a simple formula
  • Guest
Replies
2
Views
102K
JE McGimpsey
J
S
APR Question
  • Scott
Replies
11
Views
618K
Norman Harker
N
S
Counting using two sets of criteria Harlon, JE< Anyone??
  • Spiketrip
Replies
1
Views
204K
Peo Sjoblom
P
G
Filtering Data
  • Guest
Replies
3
Views
95K
Peo Sjoblom
P
P
Counting numbers II
  • Parbuster18
Replies
6
Views
123K
Andy Brown
A
You must log in or register to post here.
Back
Top