About Us

Worked like a breaze . . . much easier. . . THANKS

"RLA49" wrote:

Hi,
Try this: =IF(A1=0,0,IF(OR(A1=339,A1=352),4,1))

Your formula did not evaluate any cell for the values you specifed. 'A1' is
the cell where the data is. This formula goes in a different cell.

RLA49

"Jeanette" wrote:

I am trying to create a countif formula that meets the following criteria:

if <=0, 0
if =1<=338, 1
if =339, 4
if =340<=351, 1
if =352, 4
if =353, 1

So far, I can only get a value of 1 to return for all criteria with the
following formula:
=+COUNT(IF(430<=0,0,IF(E430=1<=338,1,IF(E430=340 <=351,1,IF(E430353,1,IF(E430=339,4,IF(E430=352,4, 0)))))))

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTIF COMBINATION??	Heather	Excel Worksheet Functions	1	April 26th 05 02:44 AM
Combining IF and COUNTIF based on two columns	maxtrixx	Excel Discussion (Misc queries)	5	March 31st 05 06:21 PM
COUNTIF in one colum then COUNTIF in another...???	JonnieP	Excel Worksheet Functions	3	February 22nd 05 02:55 PM
Countif - Countif	maswinney	Excel Worksheet Functions	3	November 15th 04 11:06 PM
countif, again	Liz G	Excel Worksheet Functions	2	November 1st 04 11:20 PM

Menu

About Us