Excel Worksheet Functions - Page 1181

Thread / Thread Starter	Last Post	Replies	Views
how do I calculate staffing ratios Xfiles325	by ExcelBanter AI	5	12,418
create formula to add 15 minutes to previous time value Bruce	by ExcelBanter AI	2	12,425
How do I add an equals sign to a cell that already has numbers in George	by ExcelBanter AI	9	12,430
How to use Ara and ARP fucntions on Ms Excel? ANJAN	by ExcelBanter AI	7	12,442
Calculating Sortino Ration (Downside Deviation) TimH	by ExcelBanter AI	8	12,456
Why put a plus sign after = sign in a formula kMan	by ExcelBanter AI	3	12,460
extend the range of cells for a drop down list Marge	by ExcelBanter AI	9	12,464
split cell diagonally and fill half with color yooper	by ExcelBanter AI	2	12,541
'TABLE' array function JB2010	by ExcelBanter AI	5	12,556
How to calculate the third friday of a month? KJP	by ExcelBanter AI	2	12,558
formula to a minimum value of zero if a negative number Jay M 0425	by ExcelBanter AI	3	12,603
Normalizing Excel data across rows Greenstorm	by ExcelBanter AI	3	12,660
Calculate 60 days from Start Date - including weekends Missy	by ExcelBanter AI	6	12,674
How enter time DURATIONS mm:ss (not clock times), then sum? Roger D	by ExcelBanter AI	4	12,705
IRR / MIRR and Perpetuity Jeff	by ExcelBanter AI	8	12,714
Return the first Wednesday of each month dalymjl	by ExcelBanter AI	5	12,823
How can I make a column "float" as I scroll horizontally? DarkStone1979	by ExcelBanter AI	5	12,832
Excel X for Mac - show formulas Jim Carlton JMS	by ExcelBanter AI	4	12,864
How to make "X" have the value of 1? lettbonn	by ExcelBanter AI	2	12,913
how to insert a special character (arrow) in IF statement HA@Work	by ExcelBanter AI	4	12,976
Need formula to calculate subtotal before sales tax HLR2007	by ExcelBanter AI	5	12,978
How do I find/replace data in selected cells only Mike_3333	by ExcelBanter AI	7	13,029
How do I assign a number to a name in another column? Michelle	by ExcelBanter AI	5	13,042
CAN VLOOKUP SEARCH AN ENTIRE WORKSHEET INSTEAD OF RANGE OF CELLS BROCK8292	by ExcelBanter AI	4	13,062
Count and Sum data in same Pivot table [email protected]	by ExcelBanter AI	7	13,069
my paste special function won't let me copy formulas squintana	by ExcelBanter AI	4	13,082
Vba - Save but don't close Sandy	by ExcelBanter AI	4	13,128
Geometric Standard Deviation Sandman	by ExcelBanter AI	12	13,159
Find position number of third space Steve Stad	by ExcelBanter AI	7	13,174
Can Excel automatically insert current date in a cell? AdrianXing	by ExcelBanter AI	25	13,226
find and replace nonzero values with 1 Amylacc	by ExcelBanter AI	4	13,229
HOW TO SET UP REMINDERS IN EXCEL? Janelle	by ExcelBanter AI	2	13,254
Delta E(cmc) formula Michelle7890	by ExcelBanter AI	11	13,260
Find the Date of the Next Friday Thomas M.	by ExcelBanter AI	13	13,263
I need to divide multiple cells by a single control cell in order. LRM	by ExcelBanter AI	3	13,269
Excel: Change Direction of Group/Outline Function Ray Carter	by ExcelBanter AI	5	13,355
How do I round time down to the nearest half hour? KatJ	by ExcelBanter AI	4	13,430
merge cells button doesn't work Mark F	by ExcelBanter AI	5	13,452
My formula is =Sum(E38). How can I add text to the formula? Marie	by ExcelBanter AI	5	13,484
Calculate hours worked minus a half hour for lunch Danedel	by ExcelBanter AI	4	13,646
How do I mask a Social Security Number ###-##-nnnn? Ed H[_2_]	by ExcelBanter AI	3	13,700
How can I count items in a filtered list? Counting filtered data.	by ExcelBanter AI	44	13,785
how do I create a formula to convert kilograms to pounds Bob	by ExcelBanter AI	6	13,840
Copy only letters, not numbers Connie Martin	by ExcelBanter AI	9	13,879
inverse weighted average Dan Cotts[_2_]	by ExcelBanter AI	3	13,932
how do I use the inverse sine (sin -1) function in Excel 2007? Priyanthi Silva	by ExcelBanter AI	2	14,085
How to filter merged cells to get more than the first row Scruffy89	by ExcelBanter AI	2	14,142
Interpolate in table lookup proinwv	by ExcelBanter AI	18	14,255
I need to calculate a Geometric mean Biff	by ExcelBanter AI	8	14,269
Bond premium amortization using the constant yield method lmahaffey	by ExcelBanter AI	2	14,281
View the code in a add-in sh0t2bts	by ExcelBanter AI	9	14,377
how do I cross out something in a cell to keep it visible rose angel	by ExcelBanter AI	4	14,416
Highest total of any three consecutive numbers in a range. [email protected]	by ExcelBanter AI	13	14,436
Adding bytes, gigabytes, and megabytes in Excel NetTech	by ExcelBanter AI	4	14,521
How to keep random number from changing using RANDBETWEEN? TXlimogirl	by ExcelBanter AI	6	14,590
PMT: Daily interest compounding; monthly payment rkhughes	by ExcelBanter AI	10	14,600
Rate vs. IRR Phin Lars	by ExcelBanter AI	2	14,623
triangular distribution Yaarit	by ExcelBanter AI	4	14,645
Shaded cells won't print shaded Linda C	by ExcelBanter AI	4	14,698
need a formula to convert pounds to tons( 2000) lbs per ton Liverpool Loo	by ExcelBanter AI	5	14,704
How to insert Checkbox in excel to simply click and tick it? Keegan	by ExcelBanter AI	5	14,719
How do I run a regression on data that is not numerical? NG	by ExcelBanter AI	4	14,839
Do nothing if False! Simi Singh	by ExcelBanter AI	8	14,970
Multiply Cell Values which include text units DaveR	by ExcelBanter AI	7	15,009
Shannon diversity index formula peter	by ExcelBanter AI	11	15,015
How to I calculate 180 days from any date? Jackie	by ExcelBanter AI	2	15,105
Wildcard character in an "If" statement? ttretta	by ExcelBanter AI	13	15,135
How to change all cells from minus to plus and plus to minus Rockbear	by ExcelBanter AI	4	15,150
Average Symbol Workbook	by ExcelBanter AI	9	15,299
count function not working, keeps displaying 0 dnm	by ExcelBanter AI	5	15,400
How do I compare two columns contents for differences Denny	by ExcelBanter AI	3	15,422
Weighted Average of positive and negative % [email protected]	by ExcelBanter AI	9	15,474
Count number of digits in a cell Julieeeee	by ExcelBanter AI	7	15,553
Federal tax withholding calculations - using IF statements..? clintjjohnson	by ExcelBanter AI	13	15,615
Calculate How Long Funds Will Last ridgerunner	by ExcelBanter AI	7	15,666