"if" function.

[Cameron]

Howdy.

I want to create the following situation...

If cells f3, g3, h3, i3 = "y" then cell j3 is to also = "y".

The condition is that all 4 (f3:i3) must = "y" and then the formula must put
the text "y" into j3.

I have tried with the following but just can't get it to work....
=IF(F3:I3="y","y","")


Can anyone help...please!


Cameron.

 

[Cameron]

The reason I am doing this, is I want the final cell (j3) to go green if all
the other cells contain the letter "y". I am doing this with conditional
formating on j3, if it contains "y" then color the cell green.

 

[Vasant Nanavati]

Hi Cameron:

Make it an array formula and you're all set. Type in the formula and then
use <Ctrl Shift Enter> rather than just <Enter>. It will then look like
this:

{=IF(F3:I3="y","y","")}

and give you the desired result. The curly braces will be inserted
automatically.

Another way (without using an array formula):

=IF(AND(F3="y",G3="y",H3="y",I3="y"),"y","")

Regards,

Vasant.

 

[Paul Corrado]

Cameron

One possible solution.

=IF(F4&G4&H4&I4="YYYY","Y","")

PC

 

[Thomas]

In cell J3 enter
=IF(AND(F3="y",G3="y",H3="y",I3="y"),"y",)

A worksheet function can only change the value of the cell it is in.

 

[Paul Corrado]

Cameron,

In that case you can use

Format|Conditional Format

"Formula Is"

==$F3&$G3&$H3&$I3="YYYY"

and not bother putting the "Y" in column J.

PC

 

[Ron Rosenfeld]

Howdy.

I want to create the following situation...

If cells f3, g3, h3, i3 = "y" then cell j3 is to also = "y".

The condition is that all 4 (f3:i3) must = "y" and then the formula must put
the text "y" into j3.

I have tried with the following but just can't get it to work....
=IF(F3:I3="y","y","")


Can anyone help...please!


Cameron.

In j3, *array-enter* the formula:

=IF(AND(F3:I3="y"),"y","")

To array-enter a formula, hold down <ctrl><shift> while hitting <enter>. Excel
will place braces {...} around the formula.



--ron

 

[Cameron]

THANK YOU EVERYONE, THE ARRAY ENTRY SEEMS TO HAVE BEEN WHAT I WAS LOOKING
FOR.

MUCH APPRECIATE YOUR HELP.


CAMERON.