Help with Formula

[Guest]

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

 

[Guest]

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

 

[Guest]

in case your entry i n cell h2 has a space

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

 

[Guest]

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

 

[Dave Peterson]

The length of the formula won't matter as long as it evaluates to BUY (or
something else).

If you just try:

=h2="buy"

Do you get true or false?

if you get false, then H2 doesn't equal BUY. Noel guessed that you had
leading/trailing spaces surrounding your "buy" text.