Excel Worksheet Functions - Page 86

Thread / Thread Starter	Last Post	Replies	Views
Caculating a "staircase" discount Thomas Refsdal	by kk	3	633
CAGR Mike	by Myrna Larson	4	436
CAGR jiang	by jiang	0	368
CAGR on redemption for Inital + equal periodic investments in MF? rds	by rds	3	664
Cal Bal Hr & Min TSK	by Peo Sjoblom	1	400
Calander Drop Down Box hennie van zyl	by Ron de Bruin	1	418
Calander in Spreadsheet Dolson	by Gord Dibben	3	405
Calc DStore	by DStore	2	404
calc PH NEWS	by vezerid	6	412
calc # of d, m, y, then round to nearest fraction Ruby	by Ruby	2	377
calc constant date from variable date & return with ability to rn. SusieQ'sQuest	by Frank Kabel	1	889
Poll: Calc cost pro rata (nested IF's and macro to find empty row) herbwarri0r	by herbwarri0r	2	767
Calc days between two dates and exclude leap year days scoz	by Ron Rosenfeld	5	5,254
Calc Diff Between Two Julian Date saltrm	by saltrm	5	613
Calc End Date OCD Cindy	by Ron Rosenfeld	2	621
Calc minutes and seconds difference Coach	by Coach	15	1,113
Calc mode display on worksheet Robert	by Max	7	431
Calc occurrances for weekday omitting weekend data dtoney	by Bernard Liengme[_3_]	4	754
Calc on Pivot Table Frick	by Incoherent	1	574
Calc order in pivot table with COUNT peter	by peter	2	880
Calc RSQ and exclude zeros Bruce	by vezerid	3	1,716
Calc sometimes off by a penny Access Joe	by ExcelBanter AI	6	9,417
Calc staff vacation time based on more than 1 criteria Tacrier	by Tacrier	0	859
calc. an anniversary date(50 years) after marriage date in excel datakop	by Ashish Mathur[_2_]	3	2,259
Calc. Avg. Instead of SUMPRODUCT sahafi	by sahafi	4	668
calc. formula for % Frustrated in NY	by Niek Otten	1	384
Calciation AH	by Shane Devenshire[_2_]	1	648
Calcing DOB Ian Sheppard	by Gord Dibben	4	387
Calcs & Data Validation Andrew	by T. Valko	3	448
Calcualted Fields in Pivot Tables Nigel Drinkwater	by Kevin McCartney	1	489
Calcualting hours Charles Bostic	by Bob Phillips[_3_]	6	357
Calcualtion days in month from 2 dates phocused	by vezerid	10	862
Calcualtion of renewal Latha	by Latha	0	561
Calcualtion of renewal Latha	by Latha	0	586
Calcualtion of renewal Latha	by Roger Govier	1	614
calcuate bond yields engineer	by Fred Smith	8	1,032
calcuate sales by date and segments Pete Petersen	by Pete Petersen	2	690
Calcuate totals based on specific criteria Dhardy	by Jacob Skaria	1	389
Calculat an expiration date old coach	by old coach	0	603
Calculat years married or age of someone on today's date Chersie	by Chersie	4	674
calculate Susan	by Dave F	1	485
calculate Joye	by Joye	2	499
Calculate Eva	by Eva	3	391
Calculate Carbob	by Carbob	2	418
Calculate running average but not count a zero. marsjune68	by marsjune68	3	1,723
Calculate # days from today in a Pivot Table Orrin	by ryguy7272	10	1,920
Calculate # of Days from one date to another jscano	by Ron Rosenfeld	2	2,408
Calculate # of years JT	by Fred Smith[_4_]	6	719
Calculate % Amin	by Ron@Buy	4	627
Calculate % from list of scores or ratings P. Hayes	by P. Hayes[_2_]	3	686
Calculate % of events based on days worked Karen	by bpeltzer	1	432
Calculate 'exact' age in EXCEL Zanny Garbett	by Niek Otten	4	2,246
Calculate 2 Standard Deviations Michael	by [email protected]	2	1,799
Calculate 52 weeks Rainey	by [email protected]	6	1,206
Calculate 60 days from Start Date - including weekends Missy	by ExcelBanter AI	6	12,674
Calculate a 30-day moving average based on the last x number of entries and date gimiv	by Domenic	14	2,289
calculate a continuous percent of attendance -if then using count. IrisRandom*	by IrisRandom*[_2_]	2	4,295
Calculate a Date Mac55	by Shane Devenshire	6	445
Calculate a date based on a weeknumber brian martens	by Earl Kiosterud	2	2,490
Calculate a date based on period and year Sam	by Trevor Shuttleworth	5	612
Calculate a date based on values in other cell, worksheet KS	by KS	4	412
calculate a date X number of days before/after given date Samantha	by T. Valko	1	3,309
calculate a date, 10 weeks after a set date Guido Cole	by Biff	2	1,270
calculate a date, 10 weeks after a set date & return a specific da Art3277	by T. Valko	2	1,158
calculate a formula instead of returning text Jonrey	by Harlan Grove	21	1,609
Calculate a formula when enter text KG	by KG	7	680
calculate a MEDIAN using multiple criteria? MetricsShiva	by MetricsShiva	0	1,538
Calculate a number for 80% of column Hennie[_2_]	by Hennie[_2_]	2	1,027
calculate a part of a worksheet History Lover	by Charles Williams	2	513
Calculate a quantity rebate Sige	by Sige	1	636
Calculate a ratio of two numbers to the total rhh29	by rhh29	2	3,678
Calculate a sentences width based on lookup Phil Delaney	by jerry_maguire	1	483
Calculate a SUMIF if criteria is between 2 date ranges Anthony P	by Carim	4	1,558
Calculate a value between 2 times Maresa	by Chip Pearson	1	549
Calculate a work day Jean	by Jean	2	450