Thank you, I will try. Does it matter that h2 is a long =if(and() statement.
I am doing this for a stock stop point. So once I get this number in h2 i
need to figure if the high of the following(x) periods has been = to or
higher than that number. ANy ideas on that. Thank you for your time.

noel


"duane" wrote:

in case your entry i n cell h2 has a space

=if(trim(h2)="BUY",e2*1.02,"")

"Michael M" wrote:

Hi
Works fine for me !!
Have you got any data in e2 ??
Regards
Michael

"zmr325" wrote:

Goodevening,

How do I get a number to show up in a cell if I wrote this formula,

=if(h2="BUY",e2*1.02,"")

RIght now I wrote this and nothing appears for any corresponding "buy". I
appreciate the help.

Noel