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

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

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

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

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.



zmr325 wrote:

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

--

Dave Peterson