Hi!

Do you mean to apply this logic to cells in the same row?

Like this:

B1 1500 C1 1.5 E1 < 150,000

If so, try this:

=AND(B11500,C11.5,E1<150000)

Will return TRUE or FALSE

If you want to count how many instances there are that meet these criteria:

=SUMPRODUCT(--(B1:B1001500),--(C1:C1001.5),--(E1:E100<150000))

If wanting to count, it's better to use cells to hold the criteria:

J1 = 1500
J2 = 1.5
J3 = 150000

Then:

=SUMPRODUCT(--(B1:B100J1),--(C1:C100J2),--(E1:E100<J3))

Biff

"Reluctantputerhead" wrote in
message ...
I am trying to get any rows that are true to this criteria to be identified
somehow in Microsoft Excell 2003. This is just an example of what I need
and
would appreciate any direction to go or even to see the formula written
so I
can copy and paste it would work.

( Column B 1500 ) & ( Column C 1.5 ) & ( Column E < 150,000 )

Thanks,

Rick Davis
Ph# 503-774-6600