|
|
Checkbook calculations by
MDS1267
I am trying to create an Excel worksheet to calculate my checkbook. I want to
be able to enter different transactions and have them added or subtracted
from...
|
|
2 |
3,581 |
|
|
Complex AND OR Formula by
Colin Hayes
HI
I need to express something in a formula , and am having trouble with
it.
I need to say this :
IF E2 CONTAINS "1bx" OR "2bx" OR "3bx" OR "4BX" AND J2...
|
|
9 |
3,007 |
|
|
Count function seeing formulas as data by
robinessex
Can you change the count function seeing formulas in cells as data. This
makes the function completely useless. I have an array 1000 cells X 500
cells. I...
|
|
5 |
2,405 |
|
|
|
|
4 |
1,857 |
|
|
|
|
2 |
1,413 |
|
|
|
June 6th, 2010 11:16 AM
by Mike
|
1 |
1,235 |
|
|
xdate in Windows 7 by
Help with scheduling issue
I finally entered the world of Windows 7, albeit only because my laptop died.
I am a historan who needs to calculate dates into the 18th century. Xdate...
|
|
2 |
1,500 |
|
|
Trying to get this if statment to work by
Cerealkiller via OfficeKB.com
I have excel 2000. I am trying to get this formula to work. It does not give
me any errors or anything It just will not return the number in the cell that
it...
|
|
1 |
1,347 |
|
|
Calculating pay dates by
BW
If a date is a friday, I want to display the previous Thursday (MM/DD/YYYY).
If a date is a Saturday - Thursday, I want to display the Thursday as a date...
|
June 6th, 2010 04:58 AM
by BW
|
4 |
1,232 |
|
|
Totaling columns by
John
I was so impressed with the wonderful responses and spot on answers to my
first question on this site I thought I would give this one a try. I did try
to...
|
June 6th, 2010 03:15 AM
by John
|
4 |
1,158 |
|
|
Moving Column data formula by
Puzzled
I have information in column A of a task sheet. The information goes from row
1 thru 35. Column B is where I place a "x" to say the task need to be
completed....
|
June 6th, 2010 01:48 AM
by FSt1
|
1 |
1,027 |
|
|
Weibull function in Excel by
Barbo
I have a survival dataset (see below). I want to fit to Weibull function
S(t)=EXP(-alpha*Time^gamma). If I use Excel Solver, alpha=0.00367 and
gamma=2.32. If...
|
|
3 |
1,210 |
|
|
|
|
6 |
1,567 |
|
|
|
|
3 |
1,132 |
|
|
excel by
benney
I have a spread sheet and in it i have data validation tables when i finish
picking from them and email the sheet i then want to clear the info in the
tables...
|
June 5th, 2010 08:19 PM
by Steve
|
1 |
877 |
|
|
|
|
1 |
819 |
|
|
|
|
1 |
1,139 |
|
|
Simplify Weighted Average Formula by
ferne
I have a s/s that has the months of the year across the top and below 3
categories for each month and I want a weighted avg for each product. eg:
A B ...
|
June 5th, 2010 02:37 PM
by ferne
|
4 |
789 |
|
|
|
|
1 |
912 |
|
|
|
June 5th, 2010 05:04 AM
by ferne
|
0 |
877 |