Microsoft Excel Worksheet Functions

W
=IF(I2="",IF(F3>0,F3,""),IF(F3>0,(F3+1)*(I2+1)-1,"")) ERROR??
  • wstsquad
Replies
0
Views
141
wstsquad
W
P
Set non-continuous PrintArea via Function / Name
  • Philipbrown77
Replies
0
Views
53
Philipbrown77
P
G
Split one cell in the middle and fill each with one color
  • Guest
Replies
6
Views
50K
sky curl
S
E
Is there a Subtract If function
  • Eric
Replies
3
Views
28K
MDHUM
M
L
How do I get Excel to display which financial year a date is in?
  • LemLems
Replies
6
Views
24K
PRITESH PARMAR
P
G
Is it possible to use Excel's SLOPE function on a non-continuous r
  • Guest
Replies
4
Views
8K
NMAN
N
M
Keyboard Shortcut to reach "Name Box" in Excel
  • mehul.hathi
Replies
4
Views
6K
zopfan
Z
N
Need (Excel) formula to make Mark sheet with Automatic Grading
  • Need Formula for Mark Sheet
Replies
15
Views
49K
Bibek Shrestha
B
R
Stop automatically changing value in =RAND or =RANDBETWEEN
  • RAND
Replies
10
Views
92K
arslanu2
arslanu2
J
excel 2003: how do I fix: "Style 'Comma' not found"
  • jrp9206
Replies
4
Views
13K
1945huda
1
G
Using results of VLOOKUP in another formula
  • Guest
Replies
6
Views
8K
Joshuavdh
J
M
Never save Sheet1 of my workbook. Or some other solution to my problem?
  • Marvin Hlavac
Replies
5
Views
494
omar88
O
D
Add criteria to sumproduct Greater than or equal to
  • Diddy
Replies
6
Views
2K
Amin Sabbagh
A
P
Link Password Protected Worksheets to Master
  • PolQueen
Replies
3
Views
475
nette
N
S
Calculating Phone Bills Help Please
  • Sh0t2bts
Replies
4
Views
3K
Mannypros
M
G
Why do my rows automatically hide in Excel?
  • Guest
Replies
3
Views
9K
Tosh G
T
G
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER.
  • Guest
Replies
8
Views
11K
Judge Spread(sheet)
J
G
Pull last word from a text string in Excel
  • Guest
Replies
9
Views
11K
Micky Avidan
M
M
Need VLOOKUP to Work Two Ways
  • MuseCO
Replies
0
Views
677
MuseCO
M
S
Excel is not copying my formulas correctly when I drag them down
  • SV
Replies
6
Views
41K
cecil.lambino
C
M
Daily Time Sheets with Rounding
  • MIkeC
Replies
1
Views
883
MIkeC
M
C
Adding up total hours worked on employee schedule using various criteria
  • CGF2704
Replies
0
Views
623
CGF2704
C
A
Cannot get previous data after ctrl + w
  • AmythSyngh
Replies
0
Views
627
AmythSyngh
A
G
How can you convert the false/true into 1/0 in Excel?
  • Guest
Replies
4
Views
39K
Dr John Medhurst
D
J
Excel doesn't print the background fill color chosen for a cell
  • Joe Palazzo
Replies
5
Views
37K
Anni
A
P
IF AND Nested Functions - Formula Not Working
  • Pickles
Replies
0
Views
560
Pickles
P
L
Sliding scale for Mark Up
  • Larry Holmes
Replies
0
Views
843
Larry Holmes
L
G
Workday function linked in an argument of If formula.
  • Guest
Replies
14
Views
1K
tiger7ail
T
G
Return next non-Blank Cell in a Column ?
  • Guest
Replies
4
Views
22K
v_night
V
G
IF Function Multiple logical tests - Syntax
  • Guest
Replies
10
Views
4K
JAYSON
J
P
Help with logical function
  • PT
Replies
3
Views
636
Brendan77
B
G
How to UNCONCATENATE cell values
  • Guest
Replies
6
Views
105K
Mac123
M
G
excel: count uppercase letters in a cell
  • Guest
Replies
14
Views
19K
Aabid khan
A
M
Using Excel to calculate future dates with various intervals
  • MH
Replies
8
Views
33K
aldrin
A
J
how do you force a new line in a formula in Excel?
  • JeffRI
Replies
6
Views
166K
Andy Spry
A
S
How to make "countif" on a filtered excel-list? i.e. like subtotal
  • Stiggy
Replies
4
Views
40K
Mark Powell
M
N
Scroll lock is stuck and won't turn off
  • nikole
Replies
6
Views
31K
walldoo99
W
T
Collapsing all groups
  • TW792
Replies
0
Views
990
TW792
T
E
IF formula for currency or Macro help.
  • EOP
Replies
0
Views
673
EOP
E
A
How to get text which is inside the brackets in excel sheet
  • arun
Replies
3
Views
1K
Jessica McGrath
J
A
Excel functions
  • Ahmad Reshad
Replies
0
Views
1K
Ahmad Reshad
A
P
multiple logical tests in an IF function
  • Priscilla
Replies
8
Views
140K
TSHEGO
T
G
  • Locked
How can I get Excel to find the first number in a list greater tha
  • Guest
Replies
7
Views
19K
John Bigbootee
J
M
Using text as data?
  • Maza128
Replies
0
Views
853
Maza128
M
G
How do I do a Reverse Find/Search in Excel?
  • Guest
Replies
3
Views
17K
justincase
J
J
Custom Number
  • jal111
Replies
13
Views
1K
marino.paunil@gmail.com
T
Countifs across multiple columns using OR
  • timotero
Replies
2
Views
737
Alfred Heiligenbrunner
D
Multiple logic tests
  • danjfb
Replies
0
Views
822
danjfb
D
P
INDIRECT.EXT function, PULL function
  • paul
Replies
11
Views
3K
paul.moles@gmail.com
A
Comparison of columns using Conditional Formatting
  • Andrea
Replies
3
Views
720
MyVeryOwnSelf
You must log in or register to post here.
Top