Excel Worksheet Functions - Page 1180

Thread / Thread Starter	Last Post	Replies	Views
NZ function equivalent in Excel jg	by ExcelBanter AI	7	10,024
Sum values if date is before today James	by ExcelBanter AI	4	9,668
Where can I find a simple paying in and out with Totals sheet Les Edwards	by ExcelBanter AI	2	9,572
Setting intercept to zero with SLOPE/STEYX/etc [email protected]	by ExcelBanter AI	4	9,715
Is there a Division funtion in Excel? Seaflower	by ExcelBanter AI	4	9,640
how do i winsorize data in excel Samira Pimentel	by ExcelBanter AI	2	10,181
Subtracting one list from another list Brian	by ExcelBanter AI	3	10,857
Can SUMPRODUCT be made to ignore text Thanks	by ExcelBanter AI	7	10,258
Excel - Convert int value secs past midnight into time 53100=2:45 Zuly	by ExcelBanter AI	2	9,640
count all text values except a certain one justjill111	by ExcelBanter AI	6	9,562
How can I give text (A,B...) a number value in Excel (A=1, B=2..) Pete	by ExcelBanter AI	4	9,918
How do I compute annual rate of return in Excel? vg	by ExcelBanter AI	5	9,455
What formula is used for subtracting a range of different cells f. tim	by ExcelBanter AI	3	9,670
Looking for excel function to convert hex to Ascii SuperUke	by ExcelBanter AI	2	10,005
Arabic Numbers Mohamed Attia	by ExcelBanter AI	10	9,645
Greater than AND Less than Time Q Seanie	by ExcelBanter AI	3	9,526
Showing 0 after decimal with ROUND Libby	by ExcelBanter AI	5	10,555
My Excel 2007 won't multiply. (ex. =C3*D3 enter) ... nothing ! Joanne	by ExcelBanter AI	3	9,315
CountIf Condition based on lookup in a list of values Eric E	by ExcelBanter AI	6	9,304
Despite formula I use (for example SUM) result is always zero. Anida	by ExcelBanter AI	6	9,229
Logical test IF a decimal was typed in a cell jheath.bc	by ExcelBanter AI	8	9,456
calculating payment terms "End of Month +30". Dorian74	by ExcelBanter AI	3	10,435
more arguments have been specified for this function than are allo pm	by ExcelBanter AI	3	9,251
Custom Sort Order - Wildcard? Budget Programmer	by ExcelBanter AI	2	10,520
How do I caluclate an Annual Percentage Rate in Excel? Lisa M	by ExcelBanter AI	32	9,552
Turn a four digit number into pounds & pence Kolsballs	by ExcelBanter AI	6	9,756
Why do Excel cells not calculate until I hit "save" Bill R	by ExcelBanter AI	3	9,174
How do I subtract 1 hour from one cell and input it another? Steven	by ExcelBanter AI	6	9,201
Assigning a number value to text SoupNazi	by ExcelBanter AI	6	9,251
How do I set up a "Random Number" button in Excel? jnoriega	by ExcelBanter AI	2	9,886
Trying to calculate average call length pilates_jocelyn	by ExcelBanter AI	7	9,616
anova post-hoc analysis: tukey test Ross	by ExcelBanter AI	6	9,497
Advanced Filtering is Unavailable Beau	by ExcelBanter AI	4	9,097
Converting decimal fractions of minutes to seconds ronnie-g	by ExcelBanter AI	13	10,090
Pages in a worksheet linked, how to unlink?? Meenie	by ExcelBanter AI	2	9,166
goal seek minimize function TaiwanSwede	by ExcelBanter AI	3	10,600
NonLinear R-squared (R2) Biocellguy	by ExcelBanter AI	3	9,300
Loan Schedule with Balloon Payment R0bert Neville	by ExcelBanter AI	7	9,092
Change color of rows every time value in first column changes Natasha	by ExcelBanter AI	5	9,080
Do not allow negative numbers in cell JNW	by ExcelBanter AI	5	9,189
converting days into weeks chedd via OfficeKB.com	by ExcelBanter AI	5	9,034
Conditional formating to highlight dates 30, 60, and 90 days out? Splatme	by ExcelBanter AI	8	9,484
parent/child relationship between rows? Doug	by ExcelBanter AI	4	10,783
How to insert infinity symbol in excel? Zhead	by ExcelBanter AI	7	9,163
Custom Number Format to abbreviate to Millions Pierre	by ExcelBanter AI	4	9,159
Using Match function with duplicate values in an array Richard	by ExcelBanter AI	3	9,005
Convert 1.1B to 1,100,000.00 SteveM	by ExcelBanter AI	6	9,423
Is the first character a number or letter bactfarmer	by ExcelBanter AI	13	9,218
I need a formula to mark up a product by 200% StitchWitch	by ExcelBanter AI	7	9,115
Count Text to get a Percentage Craig	by ExcelBanter AI	5	9,023
How can i invert the selection of cells in Microsoft Excel 2007 heya	by ExcelBanter AI	3	8,918
Filter in Rows not columns Russell	by ExcelBanter AI	4	8,961
How to use Excel to do likelihood ratio chi-squared test? Michael	by ExcelBanter AI	2	10,203
how do i convert data with miliseconds to just h:mm:ss bingo983	by ExcelBanter AI	7	9,966
lookup combine vlookup with hlookup Doug	by ExcelBanter AI	2	8,931
How to nest a left function within a sumif function? LisaK	by ExcelBanter AI	2	10,696
Standard Deviation including blank cells John D[_2_]	by ExcelBanter AI	8	9,597
Trying to move photo behind text. "Send back" doesn't work. Judy	by ExcelBanter AI	5	9,600
How to roll up columns or rows for summary purposes? IgorHendriksen	by ExcelBanter AI	2	8,928
How to use SUMIF to return sums between two values located in cells ScottBerger	by ExcelBanter AI	2	9,048
Flipping a last name comma first name in the same cell Tina Marie	by ExcelBanter AI	9	9,064
Get Date of Birth from a ID Number Lloyd	by ExcelBanter AI	2	8,879
Converting EST time in IST Shesh	by ExcelBanter AI	2	8,718
import country flag in excel Eckart	by ExcelBanter AI	3	9,464
Average only cells that contain numbers April	by ExcelBanter AI	3	8,792
SUMIF criterion to match the first 5 characters. Fred Holmes	by ExcelBanter AI	3	9,450
Formula in a cell to calc FUTA tax 12by8	by ExcelBanter AI	10	9,551
copy rows to new sheet based on specific cell value dlballard	by ExcelBanter AI	5	8,911
I need to display "Good Morning" or "Good Evening" based on NOW() Wesley	by ExcelBanter AI	7	9,838
how do i set formula to be equal to a value plus or minus 1? Aaron	by ExcelBanter AI	4	8,816
FORMAT CELL TO MILLIMETERS kjboyle	by ExcelBanter AI	4	11,180
how to find #ref! invalid cell references within cell formula Brotherharry	by ExcelBanter AI	7	8,768
How can I password protect a hidden column in Excel? Ira.Stoller	by ExcelBanter AI	9	8,782
Nested Greater than or less than if statements charlie	by ExcelBanter AI	6	8,688
Determine if a month falls between two dates. Robert R	by ExcelBanter AI	6	8,751