Excel Worksheet Functions - Page 5

Thread / Thread Starter	Last Post	Replies	Views
LINEST with r2 = -1.18 ??? [email protected]	by [email protected]	0	817
Sum columns based on conditions shani1975	by Claus Busch	1	786
Adding a max percentage to existing formula JedSrq	by JedSrq	2	894
Round up by 0.5 if =.25, down to integer if <.25 [email protected]	by Luannguyen992	4	998
How to put space in between each Character in same cell with formula Sunil V	by DungSports	7	958
Formula That Checks For Changes tb	by Claus Busch	7	1,295
Excel Pivot Table How to Sort data as Percent of Row Pat	by bulong	9	11,076
Prevent rounding up and down TerrySmith33	by Claus Busch	2	1,215
Excel spreadsheet formula to count numbers in PivotTable column [email protected]	by GS[_6_]	3	1,333
Excel 2016 IF function wrong answer Leilan	by Leilan	0	1,343
Comparing Stop Watch Times Curtopia	by Claus Busch	3	1,460
Extract date / extract time / strip data Smurfy	by cachmangmuasam	14	2,951
Change Excel Date Format [email protected]	by tinhdauhcm1	1	1,562
Excel 2003 worksheet tabs missing at bottom of my laptop display Quixote	by [email protected]	4	11,282
Highest total of any three consecutive numbers in a range. [email protected]	by ryno_19	12	13,464
Help with multiple IF Tarlis Machado	by Claus Busch	3	1,284
How to add random cells and get a sum value in another cell than status bar. Umi	by GS[_6_]	4	1,290
sum cells with specific text in comments phillip cole	by Claus Busch	18	3,469
Simplify formula [email protected]	by Txlebang106	1	1,495
Array Formula to return Header L. Howard	by L. Howard	8	1,491
Excel Dates [email protected]	by [email protected]	1	1,265
Help with IF function Michelle	by [email protected]	14	2,616
Dynamic Range Name that's driving me nuts [email protected]	by GS[_6_]	8	1,608
First day of the next bi-weekly Sunday to Saturday payroll period after a given date ElizabethWells	by GS[_6_]	6	1,532
Need Function that returns active sheet name arcibald tuttle	by Claus Busch	1	1,370
sum last N rows not being a weekend [email protected]	by [email protected]	3	1,105
Calculating Date of next birthday Ken Lumley	by [email protected]	8	3,180
How to calculate hours based on certain criteria [email protected]	by [email protected]	6	1,132
Excel POWER Function \| What's the formula for Punjabi Mathematician	by Punjabi Mathematician	3	1,423
If function with lookup alphanull	by alphanull	4	1,084
Error in Calculating investment return in Excel using IRR or XRR [email protected]	by ltomama0945	2	1,746
Future Value with Interest the compounds every 3 years AdmiralAJ	by LeHuonngh2	2	1,308
How can i calculate the first sunday of each month [email protected]	by [email protected]	1	1,094
If statement to compare time cell to a time Z-Man-Cek	by Tindien3579pro	16	5,286
Extracting only birthday and month from ID number Hannes Basson	by ssixsl	4	1,114
How to detect negative value cells from large size of data [email protected]	by Claus Busch	2	1,114
Require help with PROPER function in excel [email protected]	by Claus Busch	1	1,320
Nested IF AND returning #VALUE! Paul Doucette	by Paul Doucette	11	2,455
I'm trying to use COUNTIFS to count how many times someone attendedtutoring, but in a data range such as 4-9 or 2-3 [email protected]	by Claus Busch	1	1,037
Calculate Interest that compounds every 3 Years AdmiralAJ	by AdmiralAJ	0	945
Edit & Paste link help Martin ©¿©¬[_4_]	by Martin ©¿©¬[_4_]	0	920
combining MIN and MAX formulas... DUV	by GS[_6_]	5	1,207
How do I set a maximum value (e.g. cap at 200) LeeLobb	by DUV	7	58,557
Using the IF and VLOOKUP Function to calculate the tax rates and tax deducted nerrawsl	by GS[_6_]	3	5,391
Need formula to test if cell is a multiple of 28, but not including 28 Wazzel	by Wazzel	4	1,778
left, search mid [email protected]	by Claus Busch	3	1,952
Countifs between a certain value [email protected]	by Claus Busch	3	1,310
Need Formula For Extracting Part Numbers tb	by tb	3	1,403
Index / Match with condition b_nuruddin	by b_nuruddin	2	1,484
Using the Time function with an IF statement Allison Mazurek	by Claus Busch	5	1,293
Formula to get the dynnamic date of the month shiva_reshs	by Claus Busch	1	1,279
Dupes in a range L. Howard	by GS[_6_]	7	1,482
Join two functions b_nuruddin	by b_nuruddin	2	1,308
Convert QuickBooks time format to excel to calculate Misty May	by [email protected]	3	2,329
How do I calculate variance between numbers? copitta	by [email protected]	5	2,974
data arrangement Nitya Satheesh	by Nitya Satheesh	4	1,762
Displaying all combinations of a range of numbers Mally	by mpokos	5	3,143
SUMIFS linked to other workbook, returns #VALUE! GijsKijlstra	by GijsKijlstra	2	1,786
Min function pull down formula L. Howard	by L. Howard	4	1,713
time decision for open file in Excel [email protected]	by [email protected]	3	2,549
Can't insert a new worksheet [email protected]	by [email protected]	0	1,619
data analysis Nitya Satheesh	by Nitya Satheesh	12	2,860
Date function expanded ahmed[_4_]	by ahmed[_4_]	5	1,502
Date Functions ahmed[_4_]	by ahmed[_4_]	4	1,236
Can't insert a new worksheet [email protected]	by [email protected]	0	1,251
Productivity Log drew	by ANoline	3	2,875
Productivity Statistics ANoline	by ANoline	0	1,405
How do I sort IP addresses is ascending numerical order? [email protected]	by [email protected]	0	2,286
Odd results from SUMPRODUCT variance formula JamesM1986	by JamesM1986	0	2,243
Upload an image depending on the value of cells luis vejarano	by luis vejarano	2	1,368
CONVERSION OF TEXT TO DATE via135	by wabbleknee	3	1,438
excel 2003: how do I fix: "Style 'Comma' not found" jrp9206	by [email protected]	4	4,514
alpha numeric data validation for excel [email protected]	by comin	24	5,587
FINDING OUT SATURDAYS AND SUNDAYS via135	by via135	4	1,323
IF statement to show Late Arrival [email protected]	by Claus Busch	1	1,342