

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 
2,147 


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,689 




4 
1,277 




2 
810 



June 6th, 2010 11:16 AM
by Mike

1 
729 


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 
808 


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 
661 


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 
571 


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 
631 


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 
492 


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 
596 




6 
702 




3 
614 


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 
450 




1 
372 




1 
530 


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 
354 




1 
391 



June 5th, 2010 05:04 AM
by ferne

0 
413 




2 
579 