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