G
Guest
=IF((J2<1000000>5000000),"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
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