Excel Worksheet Functions - Page 67

Thread / Thread Starter	Last Post	Replies	Views
How do I format a value when using it within a cell reference tha. packmule	by AndreasN	4	943
Numbers Mousa Al Nahar	by Bob Phillips	1	391
Must be an easy add-in Poolie'sGal	by Ron de Bruin	2	389
Nesting Formulas PLCProgrammer	by PLCProgrammer	2	560
placing Stig	by Stig	0	485
Ignore text Function Grant	by Jason Morin	3	747
how to format numbers stored as text or vice versa to use vlookup teneagle	by Myrna Larson	1	1,301
Using EXCEL 2003 how do I open a Lotus Approach 9.5 database? JHB	by JHB	4	1,142
Auto update entire columns / rows??? Kcurtis	by IC	3	1,548
Using a col of Dates by day I want to determine a wk ending date. Ken Espo	by Peo Sjoblom	4	745
If Function meekone	by Harlan Grove	1	342
If Function meekone	by Harlan Grove	4	386
Rounding Numbers Simon	by Myrna Larson	5	717
Workdays (Including Saturdays) Formula Biff	by Myrna Larson	1	554
Convert three separate columns of values to dates jack	by jack	3	2,286
How do I count shaded cells Randy	by Randy	19	3,463
HOW DO I SET UP REPEATING DATES IN EXCEL? tpapd754	by Dave R.	2	1,892
searching for values and summing the corresponding values Simon	by Biff	1	1,111
subtotal instead of sum Lon	by Debra Dalgleish	1	493
watermark in an individual cell Jim	by Debra Dalgleish	1	781
resolving a numeric cell entry for its meaning vtcrob	by vtcrob	0	915
2 Different spreadsheets on 1 page? Steph Lichtman-Price	by Steph Lichtman-Price	7	661
Auto fill option box disappeared sbrimley	by Dave Peterson	5	4,360
Converting data from a pasted document Dave	by Dave Peterson	1	664
Ghost Blank Cell References David P	by Dave Peterson	1	1,064
Adding with & Jim	by Dave Peterson	3	494
How do I set up graphic slider bars in solver to adjust scenario . Deportivofan	by Deportivofan	0	665
Converting Date of Birth to Age WendyMc	by Myrna Larson	8	2,446
IF statement w/ more than 7 arguments needed sony654	by sony654	15	1,202
Excluding 0s and blanks from a LINEST function Disco	by [email protected]	4	1,536
How do I find a value and insert new value SingaporeSling	by Biff	4	446
Keeping a transfered value the same after changing the original va DeVon	by DeVon	0	625
How do i calculate Written Down value Suresh Gagrani	by Suresh Gagrani	0	1,405
Can I count how many grey-filled cells are in a row ? AnthonyG	by Niek Otten	1	1,556
Precision problem with automated formula fill-in Erny Meyer	by JE McGimpsey	1	624
sum cells based on another cell value Anauna	by	3	3,103
Clock lehigh46	by Jason Morin	1	861
COUNT INFORMATION IN COLUMN B ONLY IF A1 MATCHES K1 COUNT THAT CE. witchcat98	by JE McGimpsey	1	1,261
Using PROPER for Columns, rows or ENTIRE spreadsheet Tom	by Tom	3	1,567
Function for Least Cost. Bryan	by Peo Sjoblom	3	902
Counting Characters in a Cell carl	by Don Guillett	2	547
date formula Juco	by Juco	2	514
If Function with Date taxmom	by taxmom	2	554
Can I use variables for workheet name references in Excel functions? Amihai Bareket	by Peo Sjoblom	1	702
SumIf Function using multiple criteria Jamie A Miller	by Peo Sjoblom	1	980
Problems Using Print Preview Jack	by Jack	2	872
two criteria in a vlookup CMAC	by C Y via OfficeKB.com	5	739
Trying to Manipulate a Mortgage Payment (HELP!) DC	by JudithJubilee	1	730
Corrupt file Recovery Nick Zalinski	by Ken Wright	1	693
If Character #8 = C Wes Paul	by Arvi Laanemets	2	353
SUMIF - HLOOKUP Combination Mark	by Bernie Deitrick	1	1,122
Exclude a cell from calculating Drew	by Bernie Deitrick	2	613
Return Multiple Results with Lookup Josh O.	by Harlan Grove	1	1,200
Multipl IF Statements - REVISION vnsrod2000	by answer guy	1	551
adding certain cells in multiple worksheets in multiple workbooks Stephen via OfficeKB.com	by Ron de Bruin	1	1,931
I Need a Formula to Auto-fill Phone Numbers in a Range twd3lr	by twd3lr	4	1,270
How sum values in column B using values in column A as the conditi oldgrayelf	by oldgrayelf	5	1,454
How do I insert the directory path in my Excel file? Insert a Directory Path in Header/Footer	by Nicole L.	2	1,549
automating copy and paste Anne	by Gord Dibben	2	392
CELL("FILENAME") JEV	by JEV	4	452
if formula = negative #, then insert a word Nicole L.	by Gord Dibben	10	1,861
ADDING NUMBERS IN COLUMNS ACROSS IN EXCEL lost in translation	by Gord Dibben	2	653
Formula Help (new to Spreadsheet) Ken Moskowitz	by Ken Moskowitz	0	550
Logical Function - Multiple IF statements vnsrod2000	by JE McGimpsey	7	792
autofilling cells Tim	by Gord Dibben	1	450
Stones and Lbs Eamon	by Harlan Grove	12	913
How do I look up a value in a table with 2 criteria? jmalies	by Aladin Akyurek	1	373
possible to have =now() at data entry and not update after that? .:mmac:.	by Peo Sjoblom	5	668
Array Functions from Alan Beban Josh O.	by Harlan Grove	13	2,030
Why would you need more the one spreadsheet for a workbook? Excel	by Dave Peterson	5	502
Can't find logical_test for "if"statement John Grossman	by Peo Sjoblom	1	411
IF WorkSheet1 A1=1 then put value of WS1 B2 in WS2 C3 else donothi DeVon	by DeVon	1	662
Using NPV Monthly JP SIngh	by Fred Smith	1	1,973
Formula Help (new to Spreadsheet) Ken Moskowitz	by Bob Phillips	4	592
Another difficult failed formula Ken M.	by Arvi Laanemets	2	457