Microsoft Excel Worksheet Functions

Post thread
S
Loan amortization schedule for variable interest rates
  • Shaun
Replies
5
Views
20K
JoeU2004
J
M
Formula to find last monday (tue, wedn, thu or friday) for a given month
  • Michele
Replies
5
Views
20K
Michele
M
L
How to Calculate APR in excel
  • Louis
Replies
2
Views
20K
Norman Harker
N
L
How do I Rank Dates?
  • Lou
Replies
6
Views
20K
Lou
L
G
Can I add a percentage formula to an IF statement?
  • Guest
Replies
4
Views
20K
Guest
G
S
Nesting AND inside the COUNTIF Function
  • suejay
Replies
9
Views
20K
hgrove
H
D
how to split date and time in one cell into multiple cells
  • Dr. Bill
Replies
6
Views
20K
Glenn
G
G
Static Timestamp without using Macros
  • Guest
Replies
2
Views
20K
Guest
G
G
Can i set up tabs within tabs on Excel?
  • Guest
Replies
5
Views
20K
Roger Govier
R
G
How to hide or replace (blank) in a Pivot Table Column
  • Guest
Replies
3
Views
20K
Guest
G
P
Re: Countif with a date range
  • Paul Corrado
Replies
2
Views
20K
mushtaque_asghar
M
F
making drop box in excel sheet
  • foxie foxster
Replies
1
Views
20K
Guest
G
M
Man hours calculation
  • Mama Mia
Replies
9
Views
19K
Marlon
M
G
reverse vlookup
  • Greg
Replies
4
Views
19K
Greg
G
M
Excel formula - select cells based upon fill color and then sum
  • mfrye
Replies
3
Views
19K
Guest
G
B
excel function to give the area of a circle?
  • bhoward425
Replies
2
Views
19K
Bill Sharpe
B
S
how do i winsorize data in excel
  • Samira Pimentel
Replies
1
Views
19K
SCrowley
S
G
Calculating p-value from Fisher's Exact Test
  • Guest
Replies
4
Views
19K
niharica.singh
N
P
Custom Number Format to abbreviate to Millions
  • Pierre
Replies
3
Views
19K
Pierre
P
W
CountIf on Upper/Lowercase
  • ws
2
Replies
34
Views
19K
Dave Peterson
D
B
Formula doesn't work unless hit enter again
  • Bobby
Replies
4
Views
19K
Gord Dibben
G
S
Trouble with vlookup and numbers stored as text
  • SantaClaus
Replies
3
Views
19K
Matt Richardson
M
P
more arguments have been specified for this function than are allo
  • pm
Replies
2
Views
19K
gibbylinks
G
P
How many Standard Deviations above and below the mean each number is.
  • pkaraffa
Replies
4
Views
19K
[email protected]
P
G
What formula can you use to compound monthly returns?
  • Guest
Replies
1
Views
19K
Paul Corrado
P
I
VLOOKUP with a blank cell
  • Iriemon
Replies
5
Views
19K
Iriemon
I
J
Percentage point difference number format
  • jane
Replies
4
Views
19K
jane
J
G
how to fourth root a number on excel
  • Guest
Replies
7
Views
19K
Dave Peterson
D
G
How can Excel count the number of Friday's in a month?
  • Guest
Replies
2
Views
19K
Domenic
D
Ã
How do I make coloured drop down lists in Excel?
  • ÉannaD
Replies
3
Views
18K
Gord Dibben
G
G
How do I do a Reverse Find/Search in Excel?
  • Guest
Replies
3
Views
18K
justincase
J
P
How to do Pairwise comparison in Excel
  • Phillip
Replies
2
Views
18K
Mike Middleton
M
M
Excel Sort() Algorithm
  • Michael C
Replies
14
Views
18K
Harlan Grove
H
G
Text to columns delimited by carriage return
  • Guest
Replies
2
Views
18K
Gord Dibben
G
N
if positive... print in green, if negative print red
  • Newbie
Replies
4
Views
18K
mtkatrev
M
C
Can you calculate the number of years between two dates in Excel 0
  • Christina
Replies
4
Views
18K
Shane Devenshire
S
C
Edit Links - cannot change source
  • Code Numpty
Replies
4
Views
18K
Code Numpty
C
G
What is mathematical equation for NORMDIST (x,mean,standard_dev,TR
  • Guest
Replies
10
Views
18K
luinox86
L
M
How do you calculate cotangent in Excel 2003?
  • mowgli
Replies
2
Views
18K
Dana DeLouis
D
C
freeze panes not an option
  • Chief Pasanga
Replies
3
Views
18K
Bernard
B
M
Combine text from multiple cells into one cell - =(A1&","&A2","&A3
  • mh
Replies
5
Views
18K
CavProd
C
G
How do I add an area code to a list of phone numbers in Excel?
  • Guest
Replies
2
Views
18K
Jason Morin
J
A
"sampling - input range must be a contiguous reference"
  • Andreas
Replies
1
Views
18K
Anon
A
H
Combine Pivot tables - confused about 'how-to'
  • heyredone
Replies
7
Views
18K
Sarfaraj Desai
S
G
How to not count cells which contain a formula that returns " "?
  • Guest
Replies
9
Views
18K
Pete_UK
P
C
vlookup function in excel doesn't work in the german version - translation name?
  • Christian Bartsch
Replies
2
Views
18K
Jez
J
G
merge cells disabled how do I enable
  • Gary
Replies
2
Views
18K
Don Guillett
D
R
Trim function doesn't clean out ASCII Code 160 (Space)
  • Ronald Dodge
Replies
6
Views
18K
Harlan Grove
H
L
how to create disjoint range for formula, chart, etc.
  • Larry
Replies
1
Views
18K
hgrove
H
P
grand totals in pivot table rows
  • pat67
Replies
5
Views
18K
[email protected]
S
Top