I can't make this work. I'm using this formula
=SUM((IF((F4:F53="ok"),1,1))-(IF((F4:F53="ok"),1,0)))
I want a total count of cells in the range f4:f53 less the count of cells
with the value "ok" in the same range.

How can I change the comma location to reflect Indian Rupees?

Heres my situation: In a cell Id like to develo a nested function where I can
search for a string( 8-character serial number) listed in an adjacent cell,
and return a TRUE, FALSE, or custom message depending on whether it finds the
value or not. In my case, the database values I ...

I have the following situation:
10000
11000
12000

Good morning,
I am working on a formula that is giving me more trouble than I can
imagine and I would appreciate someone's help.
I have a spreadsheet that has information similar to this:

my worksheet has names and dates when reviews and training is due. I need to
add how many people are up to date and want to add columns totals but can not
assign a value to the cells containing the due dates. Is there a way to
adding how many I have in each column, not counting ...

To the group:
Are there any means of formatting cells to include thousandths of seconds?
And then Summing those times?
I know hh:mm:ss - standard time formatting.  This adds perfectly, but I am

This SHOULD calculate TAX in the UK for 2006 (see
http://www.tfpl.com/permanent_recruitment/candidates/pcalculator.cfm
or
http://www.listentotaxman.com/index.php?calc=1&year=2006&age=0&add=0&taxcode=&pe
riod=1&ingr=20000&Submit=Calculate)

Here's the situation: I'm trying to return a specific value to the cell based
on conditions in 4 cells in the same row. If A is valid (in this case>1966),
then I want to check B to see if that has a valid value (also >1966). If both
these conditions are true, then I want to check ...

I'm trying to display information in LOG LOG space.  I can make the
calculations, but displaying it as it would appear on Log paper is a problem.
Any suggestions?

Hi ~
I need to get a count of cells in column F that equal a number between
111000 and 111999, when the corresponding cell in column G equals 924350,
924550, 934350, or 934570.  I've tried using the below formula for the first

=IF(E3=1,299),IF(E3=2,149),IF(E3=3,100),IF(E3=5,59,0))
This is what i need,             E3=1.00 then return the value of 299
                                        E3=2.00 then return the value of 149
                                        E3=3.00 then return the value of 99

I have the following formula that multiplies the number entered in G21 by
either 49/12 or 45/12 depending if the first letter in G20 is "h" or "s".  
=ROUND(IF(LEFT(G20,1)="h",(49/12)*G21,IF(LEFT(G20,1)="s",(45/12)*G21))
I would like to modify this so that the above is true for ...

In Excel 2002+ when you hit [CTRL-F] to do a find, it allows you the
option of searching within the active sheet or the entire workbook.
Once you start a search and you specify, "Sheet" or "Workbook", that
information is stored for later searches, so when you hit [CTRL-F]

Could anyone tell me how to write a complex formula that will calculate a
running balance up to a certain value in a given column?  We reimburse
eduation expenses up to a certain limit.  What I need the formula to do is
calculate a running total until the limit it reached and ...