=IF((16.99-16)=0.99,10,0)
In this function, any number from (1.99-1) through (15.99-15) works and any
number above (16.99-16) fails.

I am using a DSUM formula to total up accounting entries for numerous
accounts. I use a named range for the database (WTB01) and a named range for
the Criteria (UCRS01)  and a formula for the SUM column (MONTH(NOW()) +28) as
follows =DSUM(WTB01,MONTH(NOW()+28,UCRS01)

iam looking for spreed sheet templates in excel

When I first installed Office 2003 my color fill button on the draw comand
line worked. It is not working now and I have been unable to correct the
problem. I have uninstalled the program and re-installed it but there is no
change.

Wondering if anyone could suggest why conditional formatting won't work
across a range of cells;  
this range is formatted as currency, and its values result from a simple SUM
function.  Cells either side have the same base formatting and conditional

Hey guys and gals,
I'm a Dummy user. I'm drawing a blank on how to do a simple formula. I want
to add several cells in a column and what ever the sum is I want to be able
to divide it by the number of cells I added. For example, I'm wanting to

I have a column of client names with some that I don't want to count.
I am able to count the number of unique clients. Is there a way to
exclude the names I don't want from the count of the total clients? I
need to wild card the names I don't want as they are entered in

cell a1 = the date
a1 could equal 9/15/2007, 8/20/2007, 9/26/2007, 5/30/2006, etc.
formula please?:
if the date in cell a1 falls in the month of september, then "1", otherwise

Hi
I am using this formula to count
=COUNT(IF((TRIM($C$4:$C$100)="C")*(TRIM($M$4:$M$100)<>"Closed"),$A$4:$A$100))
I am not getting the right results, because column $m$4:$m$100 has blank

I've got 2 columns of data and want to find out if a value in col A exists
anywhere in column B - I thought the match function might do this but I can't
work it out.
Thanks

I've written the formula below, but I'm getting a result of zero.  I'm trying
to sum cells C5:C750 where cells D5:D750 are equal to either a zero or an
#N/A value.
By just specifying the zero or just specifying the #N/A, I get the correct

Anyone willing to help me with a number of formulas in my spreadsheet.  I am
new to excel and know what I want to do but have little idea on how to do it.
If some one was willing I would be able to email the spreadsheet to them to
have a look at.

Does anyone have any ideas on how to calculate data that is listed by date
(not necessarily in date order.  I am trying to come up with a week ending
subtotal in a summary sheet from a number of different worksheets.  My data
is listed  as shown in each worksheet.  If anyone ...

Hi
I have a formula in cell - =IF(J45="","",(J45+181)), where if j45 is blank,
the cell h45  is blank or h45 has a new date, the format of the coloumn "H"
is date.

I have an excel sheet, which provided by client, In that one cell contains
formula as follows:
=IF((P42:Q42)=(P43:Q43),"In Balance","Out of Balance")
As per the above formula, My understanding is, P42 should be equal to P43