Greater Than Less Than Question
 

=IF((J2<10000005000000),"Show","Hide")

This formula is placing "Show" in every field. I want it to put "Show" in
each field that is between 1 and 5 million, and "Hide" in fields less than 1
million and greater than 5 million.

THANK YOU

Greater Than Less Than Question
 

One way:

=IF(AND(J21000000,J2<5000000),"Show","Hide")

HTH,
Paul

"Paperback Writer" wrote in
message ...
=IF((J2<10000005000000),"Show","Hide")

This formula is placing "Show" in every field. I want it to put "Show" in
each field that is between 1 and 5 million, and "Hide" in fields less than
1
million and greater than 5 million.

THANK YOU

Greater Than Less Than Question
 

=IF(AND(J21000000,J2<5000000),"Show","Hide")


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Paperback Writer" wrote in
message ...
=IF((J2<10000005000000),"Show","Hide")

This formula is placing "Show" in every field. I want it to put "Show" in
each field that is between 1 and 5 million, and "Hide" in fields less than
1
million and greater than 5 million.

THANK YOU

Greater Than Less Than Question
 

try this idea
=IF(AND(J81,J8<5),1,2)
--
Don Guillett
SalesAid Software

"Paperback Writer" wrote in
message ...
=IF((J2<10000005000000),"Show","Hide")

This formula is placing "Show" in every field. I want it to put "Show" in
each field that is between 1 and 5 million, and "Hide" in fields less than
1
million and greater than 5 million.

THANK YOU

Greater Than Less Than Question
 

Try this:
=IF(AND(J2<=1000000,J2=5000000),"Show","Hide")

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Paperback Writer" wrote:

=IF((J2<10000005000000),"Show","Hide")

This formula is placing "Show" in every field. I want it to put "Show" in
each field that is between 1 and 5 million, and "Hide" in fields less than 1
million and greater than 5 million.

THANK YOU

Greater Than Less Than Question
 

OK, correction...Here's what I meant to type

=IF(AND(J2=1000000,J2<=5000000),"Show","Hide")


***********
Regards,
Ron

XL2002, WinXP-Pro


"Paperback Writer" wrote:

=IF((J2<10000005000000),"Show","Hide")

This formula is placing "Show" in every field. I want it to put "Show" in
each field that is between 1 and 5 million, and "Hide" in fields less than 1
million and greater than 5 million.

THANK YOU