Help with Formula
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 |
Help with Formula
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 |
Help with Formula
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 |
Help with Formula
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 |
Help with Formula
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 |
All times are GMT +1. The time now is 10:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com