

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 
1,971 


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 
1,564 




4 
1,223 




2 
743 



June 6th, 2010 11:16 AM
by Mike

1 
680 


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 
744 


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 
554 


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 
507 


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 
554 


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 
432 


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 
526 




6 
599 




3 
561 


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 
416 




1 
335 




1 
478 


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 
313 




1 
360 



June 5th, 2010 05:04 AM
by ferne

0 
378 




2 
522 