Excel Worksheet Functions - Page 4

Thread / Thread Starter	Last Post	Replies	Views
Count Text to get a Percentage Craig	by ExcelBanter AI	5	9,041
I need a formula to mark up a product by 200% StitchWitch	by ExcelBanter AI	7	9,220
Is the first character a number or letter bactfarmer	by ExcelBanter AI	13	9,315
Convert 1.1B to 1,100,000.00 SteveM	by ExcelBanter AI	6	9,477
Using Match function with duplicate values in an array Richard	by ExcelBanter AI	3	9,027
Custom Number Format to abbreviate to Millions Pierre	by ExcelBanter AI	4	9,202
How to insert infinity symbol in excel? Zhead	by ExcelBanter AI	7	9,199
parent/child relationship between rows? Doug	by ExcelBanter AI	4	10,852
Conditional formating to highlight dates 30, 60, and 90 days out? Splatme	by ExcelBanter AI	8	9,515
converting days into weeks chedd via OfficeKB.com	by ExcelBanter AI	5	9,072
Do not allow negative numbers in cell JNW	by ExcelBanter AI	5	9,221
Change color of rows every time value in first column changes Natasha	by ExcelBanter AI	5	9,098
Loan Schedule with Balloon Payment R0bert Neville	by ExcelBanter AI	7	9,147
NonLinear R-squared (R2) Biocellguy	by ExcelBanter AI	3	9,348
goal seek minimize function TaiwanSwede	by ExcelBanter AI	3	10,897
Pages in a worksheet linked, how to unlink?? Meenie	by ExcelBanter AI	2	9,189
Converting decimal fractions of minutes to seconds ronnie-g	by ExcelBanter AI	13	10,287
Advanced Filtering is Unavailable Beau	by ExcelBanter AI	4	9,111
anova post-hoc analysis: tukey test Ross	by ExcelBanter AI	6	9,542
Trying to calculate average call length pilates_jocelyn	by ExcelBanter AI	7	9,715
How do I set up a "Random Number" button in Excel? jnoriega	by ExcelBanter AI	2	10,073
Assigning a number value to text SoupNazi	by ExcelBanter AI	6	9,289
How do I subtract 1 hour from one cell and input it another? Steven	by ExcelBanter AI	6	9,242
Why do Excel cells not calculate until I hit "save" Bill R	by ExcelBanter AI	3	9,222
Turn a four digit number into pounds & pence Kolsballs	by ExcelBanter AI	6	9,835
How do I caluclate an Annual Percentage Rate in Excel? Lisa M	by ExcelBanter AI	32	9,688
Custom Sort Order - Wildcard? Budget Programmer	by ExcelBanter AI	2	10,734
more arguments have been specified for this function than are allo pm	by ExcelBanter AI	3	9,266
calculating payment terms "End of Month +30". Dorian74	by ExcelBanter AI	3	10,538
Logical test IF a decimal was typed in a cell jheath.bc	by ExcelBanter AI	8	9,497
Despite formula I use (for example SUM) result is always zero. Anida	by ExcelBanter AI	6	9,242
CountIf Condition based on lookup in a list of values Eric E	by ExcelBanter AI	6	9,344
My Excel 2007 won't multiply. (ex. =C3*D3 enter) ... nothing ! Joanne	by ExcelBanter AI	3	9,348
Showing 0 after decimal with ROUND Libby	by ExcelBanter AI	5	10,662
Greater than AND Less than Time Q Seanie	by ExcelBanter AI	3	9,546
Arabic Numbers Mohamed Attia	by ExcelBanter AI	10	9,673
Looking for excel function to convert hex to Ascii SuperUke	by ExcelBanter AI	2	10,059
What formula is used for subtracting a range of different cells f. tim	by ExcelBanter AI	3	9,727
How do I compute annual rate of return in Excel? vg	by ExcelBanter AI	5	9,475
How can I give text (A,B...) a number value in Excel (A=1, B=2..) Pete	by ExcelBanter AI	4	9,993
count all text values except a certain one justjill111	by ExcelBanter AI	6	9,583
Excel - Convert int value secs past midnight into time 53100=2:45 Zuly	by ExcelBanter AI	2	9,660
Can SUMPRODUCT be made to ignore text Thanks	by ExcelBanter AI	7	10,334
Subtracting one list from another list Brian	by ExcelBanter AI	3	11,049
how do i winsorize data in excel Samira Pimentel	by ExcelBanter AI	2	10,328
Is there a Division funtion in Excel? Seaflower	by ExcelBanter AI	4	9,705
Setting intercept to zero with SLOPE/STEYX/etc [email protected]	by ExcelBanter AI	4	9,750
Where can I find a simple paying in and out with Totals sheet Les Edwards	by ExcelBanter AI	2	9,587
Sum values if date is before today James	by ExcelBanter AI	4	9,692
NZ function equivalent in Excel jg	by ExcelBanter AI	7	10,066
restricted values that can be entered mweber	by ExcelBanter AI	4	9,936
How do I add multiple comments to a cell? deberjones	by ExcelBanter AI	2	11,147
How can I make a drop down box visible within a worksheet? ( 1 2) skittles_golf	by ExcelBanter AI	42	11,169
Auto Sum, how do you turn it off?? JY	by ExcelBanter AI	4	10,335
IS THERE A DAILY MEDICATION DOSAGE LOG TEMPLATE ? AHEAZY	by ExcelBanter AI	2	9,764
Bell Curve RLind	by ExcelBanter AI	7	10,503
360-day Year Based Payment & Amortization Calculations? Kelley from NC	by ExcelBanter AI	2	9,786
How do I find a % difference between two numbers (comparing 2005 . Officer Steve	by ExcelBanter AI	6	9,919
EXCEL function;find string in entire column & return cell referenc Audit Compliance Man	by ExcelBanter AI	2	9,765
need one formula for % change in TY vs LY revenue Gene	by ExcelBanter AI	9	11,699
Calculate value at the end of nth year using CAGR Fenil Shah[_2_]	by ExcelBanter AI	5	9,742
Function to determine if AM or PM gtslabs	by ExcelBanter AI	3	9,751
random alphanumeric string [email protected]	by ExcelBanter AI	4	9,749
How to get the plus/minus at the top when grouping beac	by ExcelBanter AI	4	9,817
IF cell contains certain text return value EÃ¡n[_2_]	by ExcelBanter AI	11	9,887
PERCENTILE with an IF Clause Zeelotes	by ExcelBanter AI	3	9,831
Weekly Returns Robbins	by ExcelBanter AI	14	10,197
How to copy a vlookup formula without changing the "table_array" p not 2 excell	by ExcelBanter AI	5	10,516
what do the brackets { } mean around a formula? mark	by ExcelBanter AI	2	9,891
summing first 'n' values in a column or row Fran McConville	by ExcelBanter AI	5	10,429
Calculating gross when net is known placerpone	by ExcelBanter AI	4	10,979
How do I assign a number to a name in another column? Michelle	by ExcelBanter AI	5	13,177
Financial function - calculating loans with deferred payments Paul 022	by ExcelBanter AI	3	11,233
make multiple copies of a sheet in a new workbook galeanne	by ExcelBanter AI	4	10,161
Can I Use a Count Function for Text? ( 1 2 3) Joan NYC	by ExcelBanter AI	107	12,074