Excel Worksheet Functions - Page 2

Thread / Thread Starter	Last Post	Replies	Views
Find the UPPERCASE letter in a string gritgranite	by ExcelBanter AI	10	18,468
Vlookup finding subtotals only deco	by ExcelBanter AI	6	18,436
IF statement checking if a cell's text is red Shazzer	by ExcelBanter AI	7	18,332
Time Value Between Two Times Debbie[_4_]	by ExcelBanter AI	9	18,092
year formula returning incorrect value dbdewitt	by ExcelBanter AI	6	17,995
Custom Number Formats - Billion Dollars Rounded coastal	by ExcelBanter AI	10	17,973
In Excel, what do the dollar signs mean in $A$1 pso827	by ExcelBanter AI	4	17,895
Need (Excel) formula to make Mark sheet with Automatic Grading Need Formula for Mark Sheet	by ExcelBanter AI	18	17,843
Find & Replace: find part cell, replace whole cell katy	by ExcelBanter AI	3	17,769
Loan amortization schedule for variable interest rates Shaun	by ExcelBanter AI	6	17,760
Convert number to Million Currency format Yossy	by ExcelBanter AI	9	17,618
Is there an opposite function to "Concatenate" in Excel? drbonne	by ExcelBanter AI	8	17,603
How can the SUBSTITUTE function replace a double quote? Florence	by ExcelBanter AI	6	17,550
How to: If D4 = Yes then Calculate C4/11, if D4 = no leave blank Nate	by ExcelBanter AI	6	17,550
Solver Function - Making it Automatic JamesB	by ExcelBanter AI	9	17,465
Auto Fill function in Excel 2007 not working properly Raudawg	by ExcelBanter AI	5	17,331
calculating a discount rate mikelee101	by ExcelBanter AI	3	17,236
How do I get MROUND to only round up to the next multiple. gmac	by ExcelBanter AI	4	17,184
what is the formual for calculating running pace? tonym	by ExcelBanter AI	5	17,168
Reverse Transpose? sdmfg	by ExcelBanter AI	5	17,168
char(10) does not work to form a new line in my formula Sandy	by ExcelBanter AI	2	17,161
how to apply absolute cell referencing to multiple cells at once? TheresaP	by ExcelBanter AI	3	17,095
How can I copy and paste an entire workbook? Jordon	by ExcelBanter AI	4	16,872
Formula, automation turn red if value exceed a number Daniel	by ExcelBanter AI	4	16,865
count wednesdays within a month sato	by ExcelBanter AI	8	16,759
actual/360 and 30/360 amortization? Terry	by ExcelBanter AI	4	16,757
How can I evaluate whether a trend is positive or negative? leotoni	by ExcelBanter AI	7	16,726
COUNTIF for numbers of dates in column which are 30 days older than today [email protected]	by ExcelBanter AI	4	16,704
How do you restrict a cell to accepting only "Y" or "N" ? NickR2	by ExcelBanter AI	3	16,564
how do I print edge to edge with absolutely NO margins Girl4chuckie	by ExcelBanter AI	3	16,483
Conditional Formatting (Icon sets - 3 Arrows) Jackie	by ExcelBanter AI	3	16,480
How do I calculate a weighted median? ac	by ExcelBanter AI	7	16,388
How do i convert kg to tonnes in excel? dave1234	by ExcelBanter AI	3	16,358
Add 10 minutes to a date/time value Sarah G	by ExcelBanter AI	7	16,314
How do I make AutoSum really Sum, not Subtotal Pearl	by ExcelBanter AI	7	16,263
convert bond price to decimal including + novice	by ExcelBanter AI	10	16,148
IF OR AND in same conditional formula Ron	by ExcelBanter AI	3	16,087
how to use if,and,or functions together in excel excel novice	by ExcelBanter AI	4	16,033
Cannot expand the selection to entire spreadsheet when sorting Mikki	by ExcelBanter AI	3	16,003
If function with 3 different outcomes Max	by ExcelBanter AI	5	15,995
How do I have excel convert fractions to decimals? pgail	by ExcelBanter AI	15	15,961
How do I constantly display worksheet headers in normal view? srsmith41	by ExcelBanter AI	7	15,923
How to return first 3 digits of a number? Curalice	by ExcelBanter AI	3	15,877
Median for frequency distribution Samirkc	by ExcelBanter AI	5	15,868
SAVE AS CSV, KEEP DATE FORMAT clau	by ExcelBanter AI	3	15,867
How do I write inequality? Margaret	by ExcelBanter AI	12	15,864
Changing Numerators but not Denominators BTM	by ExcelBanter AI	3	15,787
Calculating Time from Speed and Distance? John[_6_]	by ExcelBanter AI	4	15,776
Is there a template that helps to manage condo association budget? Greg	by ExcelBanter AI	3	15,734
Formula to group into Age Ranges Donna	by ExcelBanter AI	3	15,731
Calculate How Long Funds Will Last ridgerunner	by ExcelBanter AI	7	15,646
Federal tax withholding calculations - using IF statements..? clintjjohnson	by ExcelBanter AI	13	15,561
Count number of digits in a cell Julieeeee	by ExcelBanter AI	7	15,508
Weighted Average of positive and negative % [email protected]	by ExcelBanter AI	9	15,445
How do I compare two columns contents for differences Denny	by ExcelBanter AI	3	15,413
count function not working, keeps displaying 0 dnm	by ExcelBanter AI	5	15,359
Average Symbol Workbook	by ExcelBanter AI	9	15,259
How to change all cells from minus to plus and plus to minus Rockbear	by ExcelBanter AI	4	15,137
How to I calculate 180 days from any date? Jackie	by ExcelBanter AI	2	15,076
Wildcard character in an "If" statement? ttretta	by ExcelBanter AI	13	15,036
Multiply Cell Values which include text units DaveR	by ExcelBanter AI	7	14,989
Do nothing if False! Simi Singh	by ExcelBanter AI	8	14,928
Shannon diversity index formula peter	by ExcelBanter AI	11	14,909
How do I run a regression on data that is not numerical? NG	by ExcelBanter AI	4	14,820
How to insert Checkbox in excel to simply click and tick it? Keegan	by ExcelBanter AI	5	14,712
Shaded cells won't print shaded Linda C	by ExcelBanter AI	4	14,644
triangular distribution Yaarit	by ExcelBanter AI	4	14,609
need a formula to convert pounds to tons( 2000) lbs per ton Liverpool Loo	by ExcelBanter AI	5	14,598
PMT: Daily interest compounding; monthly payment rkhughes	by ExcelBanter AI	10	14,566
How to keep random number from changing using RANDBETWEEN? TXlimogirl	by ExcelBanter AI	6	14,551
Rate vs. IRR Phin Lars	by ExcelBanter AI	2	14,548
Adding bytes, gigabytes, and megabytes in Excel NetTech	by ExcelBanter AI	4	14,431
how do I cross out something in a cell to keep it visible rose angel	by ExcelBanter AI	4	14,406
Highest total of any three consecutive numbers in a range. [email protected]	by ExcelBanter AI	13	14,396
View the code in a add-in sh0t2bts	by ExcelBanter AI	9	14,325