simple formula
 

in cell A2 I have 2
If i enter a "yes" in E2
I want F2 to equal 2 (same as A2)

I know this is simple, but I can't figure it out. Help. Thank you

simple formula
 

marley wrote:
in cell A2 I have 2
If i enter a "yes" in E2
I want F2 to equal 2 (same as A2)

What if E2 is not "yes"? Learn to always specify the "otherwise"
(else) case.

For what you have specified thus far, in F2, write:

=if(E2="yes", A2, "")

The 3rd parameter ("") leaves the cell empty if E2 is not "yes". Fill
in something else appropriate, if you want.

With the formula above, F2 will always equal A2 when E2 is "yes", even
if A2 is not 2. Is that what you want? Or did you intend something
like:

=if(and(E2="yes", A2=2), 2, "")

Thus, F2 is 2 only when E2 is "yes" and A2 is 2.

simple formula
 

Thank You!!

wrote:
marley wrote:
in cell A2 I have 2
If i enter a "yes" in E2
I want F2 to equal 2 (same as A2)

What if E2 is not "yes"? Learn to always specify the "otherwise"
(else) case.

For what you have specified thus far, in F2, write:

=if(E2="yes", A2, "")

The 3rd parameter ("") leaves the cell empty if E2 is not "yes". Fill
in something else appropriate, if you want.

With the formula above, F2 will always equal A2 when E2 is "yes", even
if A2 is not 2. Is that what you want? Or did you intend something
like:

=if(and(E2="yes", A2=2), 2, "")

Thus, F2 is 2 only when E2 is "yes" and A2 is 2.

simple formula
 

Thank You!!

wrote:
marley wrote:
in cell A2 I have 2
If i enter a "yes" in E2
I want F2 to equal 2 (same as A2)

What if E2 is not "yes"? Learn to always specify the "otherwise"
(else) case.

For what you have specified thus far, in F2, write:

=if(E2="yes", A2, "")

The 3rd parameter ("") leaves the cell empty if E2 is not "yes". Fill
in something else appropriate, if you want.

With the formula above, F2 will always equal A2 when E2 is "yes", even
if A2 is not 2. Is that what you want? Or did you intend something
like:

=if(and(E2="yes", A2=2), 2, "")

Thus, F2 is 2 only when E2 is "yes" and A2 is 2.

simple formula
 

Hi!

I love simple formulas!

Enter this in F2:

=IF(E2="Yes",A2,"")

Biff

"marley" wrote in message
ups.com...
in cell A2 I have 2
If i enter a "yes" in E2
I want F2 to equal 2 (same as A2)

I know this is simple, but I can't figure it out. Help. Thank you