Microsoft Excel Worksheet Functions

R
Rounding Negative Numbers to Zero
  • Robbie
Replies
4
Views
384K
Ron Rosenfeld
R
C
Complex formula assistance please.
  • Colin Hayes
Replies
4
Views
329K
Colin Hayes
C
S
Formula result and displayed result are different
  • spindoctor
Replies
4
Views
319K
Shane Devenshire
S
D
How can I use circular references that are allowed in Lotus 123?
  • DAVIDDON
Replies
1
Views
165K
Luke M
L
D
Template or Excel ?
  • drctest
Replies
1
Views
170K
Luke M
L
E
Searching for text
  • EBnLP01
Replies
2
Views
229K
EBnLP01
E
S
Lookup Across Multiple Columns - Return Category names
  • slf
Replies
2
Views
280K
Herbert Seidenberg
H
B
Adding Days and Hours
  • Basenji
Replies
8
Views
287K
Basenji
B
C
change date from 20-Mar-1920 to 20/03/1920 format
  • Confused
Replies
5
Views
343K
Confused
C
P
to fetch the rebate from another worksheet using itemcode
  • pol
Replies
1
Views
139K
DK
D
T
highlight cells different colors in row
  • tweetlee
Replies
1
Views
104K
RA
R
D
font in drop down
  • dlotz
Replies
1
Views
147K
T. Valko
T
D
count function ???
  • dlotz
Replies
2
Views
260K
RagDyeR
R
B
Count based on single number in string
  • Basenji
Replies
7
Views
430K
T. Valko
T
K
sumif function or something else needed?
  • kathy
Replies
3
Views
370K
Don Guillett
D
V
Does complicated sumproduct formula crashes excel?
  • vivi
Replies
7
Views
556K
Don Guillett
D
S
Excel Column Summation
  • Scott Adams
Replies
10
Views
1M
David Biddulph
D
K
I want to create an IF statement that leaves a cell blank if....
  • KK
Replies
6
Views
533K
Teethless mama
T
W
IF formula returns blank cells--only want values to show
  • Wilma
Replies
3
Views
316K
Wilma
W
T
Working with Date/Time
  • Thanks
Replies
1
Views
217K
Luke M
L
T
Showing date as day of week
  • Trevor Aiston
Replies
4
Views
298K
David Biddulph
D
P
Averaging to-date lists???
  • pjroethel
Replies
1
Views
266K
Bob Phillips
B
K
Array formulas/selecting data
  • Kalle
Replies
2
Views
183K
Jacob Skaria
J
M
row and cell highlighted
  • Mr.Param
Replies
2
Views
410K
Mr.Param
M
H
If logical function with text and numbers
  • Hugo
Replies
7
Views
403K
Rick Rothstein
R
L
Price time to cost
  • Linda
Replies
9
Views
233K
Linda
L
S
Is there a function that will return/copy an entire row?
  • snord
Replies
1
Views
32K
Liliana
L
D
Changing case
  • Dingbaticus-Maximus
Replies
4
Views
166K
Liliana
L
N
Age Date Between Two Dates to Return Value as 30, 60, 90 day
  • Nath
Replies
2
Views
196K
Jacob Skaria
J
T
how to merge execel sheets in excel 2003
  • TEJAS SHAH
Replies
5
Views
222K
Ashish Mathur
A
D
string contra VBA code
  • dlotz
Replies
8
Views
205K
Rick Rothstein
R
M
how do I get to cursor to stay on the cell when I press enter
  • MUAR
Replies
1
Views
256K
Dave Peterson
D
S
Filtering / Dynamic Dashboard Question
  • stevedemo77
Replies
5
Views
277K
Max
M
R
TRANSPOSE results in zero values for blank cells
  • ramatsu
Replies
4
Views
2M
Max
M
M
Inserting Rows and the affect on Functions
  • Mike O.
Replies
3
Views
191K
Liliana
L
J
calculate overtime at 2 different rates
  • jose123
Replies
5
Views
439K
Bill Kuunders
B
L
adding a percentage for COLA to Payroll worksheet
  • luvkisn
Replies
2
Views
180K
Rajesh Mehmi
R
B
How do I use ColorRank()?
  • billw0483
Replies
3
Views
26K
Michael.Tarnowski
M
N
customer Name against Unique customer number count
  • Nelson
Replies
3
Views
312K
Don Guillett
D
R
Double Lookup
  • ryguy7272
Replies
5
Views
260K
T. Valko
T
C
make a sound when a certain value is reached in a specific cell
  • chuck
Replies
1
Views
56K
Luke M
L
A
strike through
  • Angie G.
Replies
1
Views
206K
Dave Peterson
D
S
Vlookup with changing columns
  • suthey1
Replies
2
Views
266K
suthey1
S
F
"excel "macros may be disabled" message using an xlam file
  • frustrated
Replies
2
Views
438K
frustrated
F
A
using the ROUND function in a cell that already has AVERAGE functi
  • AmandaCollins
Replies
9
Views
47K
AmandaCollins
A
B
count based on single number
  • Basenji
Replies
13
Views
243K
Basenji
B
A
Sumifs function
  • Alan
Replies
2
Views
190K
Luke M
L
C
Using =MAX() or =MAXA() on Pivot results doesn't work
  • circuit_breaker
Replies
1
Views
76K
Teethless mama
T
C
Rounding Of Concatenated Costs Field
  • Caldo
Replies
10
Views
427K
Caldo
C
J
Circular Error
  • Johnnie
Replies
2
Views
132K
Francis
F
You must log in or register to post here.
Back
Top