Microsoft Excel Worksheet Functions

Post thread
G
Split one cell in the middle and fill each with one color
  • Guest
Replies
8
Views
93K
originalgman
O
A
Round Up Numbers to Nearest 500
  • Agnes
Replies
2
Views
32K
wangj@
W
G
12ths denominators for fractions in Excel (for pension calcs)
  • Guest
Replies
2
Views
7K
therealtiger
T
R
Determine if a month falls between two dates.
  • Robert R
Replies
5
Views
4K
exceluser01
E
A
"save as"
  • A.H.Thaim
Replies
0
Views
540
A.H.Thaim
A
J
can you anchor an image to a cell in excel?
  • jy15bill
Replies
8
Views
114K
mrol
mrol
M
Use 100 separator inspite of 1000 separator in excel
  • Montu
Replies
11
Views
25K
myvishal
M
S
Scrabble Value calculation for Welsh words
  • Scipiana
Replies
0
Views
732
Scipiana
S
J
Shelf Life Percentage
  • John
Replies
4
Views
8K
mewded
M
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
33K
Rayhna
R
A
Can Excel trigger Outlook reminder?
  • Andee39
Replies
10
Views
14K
npasari
N
D
How do i calculate Standard Deviation on Negative Numbers Only
  • daapower
Replies
3
Views
14K
vvc
V
W
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR??
  • wstsquad
Replies
0
Views
799
wstsquad
W
P
Set non-continuous PrintArea via Function / Name
  • Philipbrown77
Replies
0
Views
718
Philipbrown77
P
E
Is there a Subtract If function
  • Eric
Replies
3
Views
33K
MDHUM
M
L
How do I get Excel to display which financial year a date is in?
  • LemLems
Replies
6
Views
27K
PRITESH PARMAR
P
G
Is it possible to use Excel's SLOPE function on a non-continuous r
  • Guest
Replies
4
Views
12K
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
52K
Bibek Shrestha
B
R
Stop automatically changing value in =RAND or =RANDBETWEEN
  • RAND
Replies
10
Views
105K
arslanu2
arslanu2
J
excel 2003: how do I fix: "Style 'Comma' not found"
  • jrp9206
Replies
4
Views
21K
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
1K
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
1K
nette
N
S
Calculating Phone Bills Help Please
  • Sh0t2bts
Replies
4
Views
4K
Mannypros
M
G
Why do my rows automatically hide in Excel?
  • Guest
Replies
3
Views
15K
Tosh G
T
G
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER.
  • Guest
Replies
8
Views
13K
Judge Spread(sheet)
J
G
Pull last word from a text string in Excel
  • Guest
Replies
9
Views
12K
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
47K
cecil.lambino
C
M
Daily Time Sheets with Rounding
  • MIkeC
Replies
1
Views
2K
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
43K
Dr John Medhurst
D
J
Excel doesn't print the background fill color chosen for a cell
  • Joe Palazzo
Replies
5
Views
46K
Anni
A
P
IF AND Nested Functions - Formula Not Working
  • Pickles
Replies
0
Views
1K
Pickles
P
L
Sliding scale for Mark Up
  • Larry Holmes
Replies
0
Views
2K
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
116K
Mac123
M
G
excel: count uppercase letters in a cell
  • Guest
Replies
14
Views
25K
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
169K
Andy Spry
A
S
How to make "countif" on a filtered excel-list? i.e. like subtotal
  • Stiggy
Replies
4
Views
41K
Mark Powell
M
N
Scroll lock is stuck and won't turn off
  • nikole
Replies
6
Views
43K
walldoo99
W
Top