Microsoft Excel Worksheet Functions

N
Overtime computation and lunch break formula with IF and AND
  • navychef
Replies
4
Views
259K
Bob Phillips
B
G
What does this function do =+IF(ISERR(F27/G27),0,F27/G27)
  • Guest
Replies
6
Views
105K
Guest
G
G
How do I format Excel to add new rows automatically?
  • Guest
Replies
2
Views
103K
Guest
G
G
How do I capitalize and parse in the same formula?
  • Guest
Replies
2
Views
97K
Dave Peterson
D
G
Show blank cell when not Closed or Open
  • Guest
Replies
4
Views
123K
Guest
G
G
Complex overtime calculation
  • Guest
Replies
2
Views
365K
Gord Dibben
G
G
keystroke to close active workbook window
  • Guest
Replies
4
Views
170K
Gord Dibben
G
G
add to an existing function
  • Guest
Replies
5
Views
88K
Gord Dibben
G
L
Multiplying two rows together
  • Lee Harris
Replies
2
Views
180K
Bob Phillips
B
J
Bonus formula help needed
  • jiffy97
Replies
3
Views
149K
Bob Phillips
B
G
formula to look up and return smallest date from a range of dates
  • Guest
Replies
5
Views
188K
Gord Dibben
G
G
Help with if statement.....
  • Guest
Replies
4
Views
69K
Guest
G
G
FIND is not "finding" a number in a column which contains the numb
  • Guest
Replies
5
Views
139K
Gord Dibben
G
G
Multiple conditions
  • Guest
Replies
2
Views
92K
Guest
G
C
Time Intervals
  • ChrisM
Replies
1
Views
230K
Biff
B
O
Complicated question...
  • ozdemir
Replies
3
Views
154K
Biff
B
G
Grids
  • Guest
Replies
1
Views
103K
Peo Sjoblom
P
G
How do I compare two Excel columns of numbers and see non-matches
  • Guest
Replies
1
Views
69K
George Nicholson
G
G
Word wrapping in Text Box Control feature
  • Guest
Replies
2
Views
95K
Guest
G
G
Countif, then multiply??
  • Guest
Replies
4
Views
787K
Bob Phillips
B
R
Using the "IF" function?
  • Ruff
Replies
6
Views
260K
Bob Phillips
B
G
Mileage Calculation
  • Guest
Replies
5
Views
462K
Roger Govier
R
G
Instead of a negative number, I'd like to show zero...
  • Guest
Replies
6
Views
689K
Ron Rosenfeld
R
G
How not to show #N/A when using vlookup formula
  • Guest
Replies
2
Views
84K
Guest
G
G
Sum Multiple Criteria
  • Guest
Replies
3
Views
243K
vezerid
V
G
Sorting rows to a another sheet
  • Guest
Replies
6
Views
163K
Guest
G
G
Grouping By Date in Pivot Table
  • Guest
Replies
8
Views
675K
Dave Peterson
D
G
Can actual size of CHECK BOX be increased?
  • Guest
Replies
1
Views
170K
Ian
I
G
averaging on an "if" or "sumproduct"
  • Guest
Replies
2
Views
50K
Bob Phillips
B
F
adding IF statement to subtotal for autofiltered data
  • fbarbie
Replies
1
Views
90K
Bob Phillips
B
G
Dividing the value of a cell if another cell equals a set value
  • Guest
Replies
3
Views
472K
Guest
G
G
when I wrap text in excel it disappears? autofit does not work
  • Guest
Replies
2
Views
381K
Gord Dibben
G
G
Clipboard
  • Guest
Replies
1
Views
174K
Gord Dibben
G
G
Rows & Columns in Excel
  • Guest
Replies
2
Views
437K
Gord Dibben
G
G
Prevent selection of cells, based on value of another?
  • Guest
Replies
2
Views
140K
Guest
G
G
Erase Duplicates
  • Guest
Replies
1
Views
25K
Bernie Deitrick
B
G
Excel - create button to replace cell content with cell value
  • Guest
Replies
3
Views
144K
vezerid
V
G
formula for month(s) prior to actual
  • Guest
Replies
4
Views
265K
Guest
G
G
SUMIF - Can I total the value of cells if three other cells = set
  • Guest
Replies
3
Views
121K
Bob Phillips
B
M
Capture the Workbook Name
  • Minitman
Replies
12
Views
139K
Dave Peterson
D
G
Help me help a user in our office
  • Guest
Replies
5
Views
278K
Bob Phillips
B
G
Hyperlinks to .pdf files
  • Guest
Replies
1
Views
62K
Guest
G
G
Updating Excel forecasts into an Access Database
  • Guest
Replies
1
Views
171K
Guest
G
G
Using COUNTIF with visible rows only
  • Guest
Replies
2
Views
244K
Guest
G
0
Weighed Average
  • 0-0 Wai Wai ^-^
Replies
3
Views
75K
0-0 Wai Wai ^-^
0
G
how do get the frequency
  • Guest
Replies
1
Views
200K
Ian
I
G
Track Annual Inspection Due Dates Using Conditional Formatting
  • Guest
Replies
3
Views
242K
tony h
T
G
Calculating days & time left from start date/time to end date/time
  • Guest
Replies
7
Views
554K
Guest
G
G
Can I use a drop down list to navigate to other spreadsheets
  • Guest
Replies
3
Views
223K
Guest
G
G
if fuction
  • Guest
Replies
4
Views
82K
Roger Govier
R
You must log in or register to post here.
Back
Top