Excel Worksheet Functions - Page 7

Thread / Thread Starter	Last Post	Replies	Views
Weighted Average of positive and negative % [email protected]	by ExcelBanter AI	9	14,942
SAVE AS CSV, KEEP DATE FORMAT clau	by ExcelBanter AI	3	15,205
How to keep random number from changing using RANDBETWEEN? TXlimogirl	by ExcelBanter AI	6	14,435
Shannon diversity index formula peter	by ExcelBanter AI	11	14,485
Calculating Time from Speed and Distance? John[_6_]	by ExcelBanter AI	4	15,106
How to insert Checkbox in excel to simply click and tick it? Keegan	by ExcelBanter AI	5	14,620
Lookup Question MJ	by ExcelBanter AI	2	18,567
count wednesdays within a month sato	by ExcelBanter AI	8	15,758
Wildcard character in an "If" statement? ttretta	by ExcelBanter AI	13	14,748
Multiply Cell Values which include text units DaveR	by ExcelBanter AI	7	14,839
How to change all cells from minus to plus and plus to minus Rockbear	by ExcelBanter AI	4	15,010
How do I constantly display worksheet headers in normal view? srsmith41	by ExcelBanter AI	7	15,459
Is there a template that helps to manage condo association budget? Greg	by ExcelBanter AI	3	15,271
How can I evaluate whether a trend is positive or negative? leotoni	by ExcelBanter AI	7	15,839
Formula to group into Age Ranges Donna	by ExcelBanter AI	3	15,094
Count number of digits in a cell Julieeeee	by ExcelBanter AI	7	15,314
How do I write inequality? Margaret	by ExcelBanter AI	12	15,553
Cannot expand the selection to entire spreadsheet when sorting Mikki	by ExcelBanter AI	3	15,658
How do I compare two columns contents for differences Denny	by ExcelBanter AI	3	15,345
Federal tax withholding calculations - using IF statements..? clintjjohnson	by ExcelBanter AI	13	15,443
Repaymen of loan excel sheet with grace period etc... Morten	by ExcelBanter AI	8	17,161
How to return first 3 digits of a number? Curalice	by ExcelBanter AI	3	15,691
How do I have excel convert fractions to decimals? pgail	by ExcelBanter AI	15	15,649
Median for frequency distribution Samirkc	by ExcelBanter AI	5	15,744
Find the UPPERCASE letter in a string gritgranite	by ExcelBanter AI	10	16,881
How to do Pairwise comparison in Excel Phillip	by ExcelBanter AI	3	17,412
If function with 3 different outcomes Max	by ExcelBanter AI	5	15,839
how to use if,and,or functions together in excel excel novice	by ExcelBanter AI	4	15,796
How do you restrict a cell to accepting only "Y" or "N" ? NickR2	by ExcelBanter AI	3	16,140
actual/360 and 30/360 amortization? Terry	by ExcelBanter AI	4	16,381
ROUNDUP to nearest 1/16 (in decimals) [email protected]	by ExcelBanter AI	6	17,533
IF statement checking if a cell's text is red Shazzer	by ExcelBanter AI	7	17,228
IF OR AND in same conditional formula Ron	by ExcelBanter AI	3	15,992
COUNTIF for numbers of dates in column which are 30 days older than today [email protected]	by ExcelBanter AI	4	16,428
how to copy displayed value only? star737	by ExcelBanter AI	2	18,510
Conditional Formatting (Icon sets - 3 Arrows) Jackie	by ExcelBanter AI	3	16,167
How do you change single digits to recognized double digits? Evil with a K[_2_]	by ExcelBanter AI	5	18,551
Add 10 minutes to a date/time value Sarah G	by ExcelBanter AI	7	16,193
Formula, automation turn red if value exceed a number Daniel	by ExcelBanter AI	4	16,444
Loan amortization schedule for variable interest rates Shaun	by ExcelBanter AI	6	17,099
How can the SUBSTITUTE function replace a double quote? Florence	by ExcelBanter AI	6	16,962
how to apply absolute cell referencing to multiple cells at once? TheresaP	by ExcelBanter AI	3	16,620
Reverse Transpose? sdmfg	by ExcelBanter AI	5	16,742
How can I copy and paste an entire workbook? Jordon	by ExcelBanter AI	4	16,590
restrict access to individual users - excel tabs Rich	by ExcelBanter AI	6	17,925
char(10) does not work to form a new line in my formula Sandy	by ExcelBanter AI	2	16,894
Calculating how many Saturdays there are between two given dates [email protected]	by ExcelBanter AI	7	19,077
How do I get MROUND to only round up to the next multiple. gmac	by ExcelBanter AI	4	17,056
How to: If D4 = Yes then Calculate C4/11, if D4 = no leave blank Nate	by ExcelBanter AI	6	17,342
Auto Fill function in Excel 2007 not working properly Raudawg	by ExcelBanter AI	5	17,094
calculating a discount rate mikelee101	by ExcelBanter AI	3	17,152
Vlookup finding subtotals only deco	by ExcelBanter AI	6	17,879
Solver Function - Making it Automatic JamesB	by ExcelBanter AI	9	17,382
How to automaticaly insert user name (login name) in excel? dheitz	by ExcelBanter AI	7	19,311
Is there an opposite function to "Concatenate" in Excel? drbonne	by ExcelBanter AI	8	17,370
Find & Replace: find part cell, replace whole cell katy	by ExcelBanter AI	3	17,454
Percentage point difference number format jane	by ExcelBanter AI	5	20,735
Convert number to Million Currency format Yossy	by ExcelBanter AI	9	17,507
year formula returning incorrect value dbdewitt	by ExcelBanter AI	6	17,758
Need (Excel) formula to make Mark sheet with Automatic Grading Need Formula for Mark Sheet	by ExcelBanter AI	18	17,662
Custom Number Formats - Billion Dollars Rounded coastal	by ExcelBanter AI	10	17,765
In Excel, what do the dollar signs mean in $A$1 pso827	by ExcelBanter AI	4	17,830
Time Value Between Two Times Debbie[_4_]	by ExcelBanter AI	9	17,986
Text to Columns wizard greyed out vic1	by ExcelBanter AI	5	19,529
Calculating growth with negative numbers Tsipi4me	by ExcelBanter AI	3	18,104
Displaying trendlines in legend (or not) [email protected]	by ExcelBanter AI	4	18,262
Adding random noise to data Augabog	by ExcelBanter AI	3	19,470
is there a function like NORMSINV for exponential distribution Stuart Douglas[_2_]	by ExcelBanter AI	3	18,769
Summing all numeric values only in cells in a column Brad	by ExcelBanter AI	5	18,709
Sumifs - greater than criteria with a Cell Reference Dweid	by ExcelBanter AI	4	18,840
Count digits before decimals and after decimals Elton Law[_2_]	by ExcelBanter AI	5	20,907
Need an Excell function that can lookup vertical AND horizontal Piet vd Berg	by ExcelBanter AI	4	19,010
EXCEL ERROR - series formula is too long BobY	by ExcelBanter AI	3	19,846
I'm going crazy, Excel returns 0 for a simple sum Eric	by ExcelBanter AI	5	19,296
Unprotect sheet command - How do I do this? TKM	by ExcelBanter AI	7	19,523