Excel Help!!
 

How would I write an excel formula using the following conditions? I keep getting an error message and I dont know what I am doing wrong

Buy if the stock price is greater than 10 and forward PE ratio is less than 15
Buy if Mkt Cap is better than 50.00 and return on assets is better than 6.00
Hold otherwise

Thanks!!

Excel Help!!
 

Hi,

Buy if the stock price is greater than 10 and forward PE ratio is less than 15
Is there an "OR" here?
Buy if Mkt Cap is better than 50.00 and return on assets is better than 6
Hold otherwise


isabelle

Le 2017-03-01 à 21:38, hayley_n2008 a écrit :
How would I write an excel formula using the following conditions? I
keep getting an error message and I dont know what I am doing wrong

Buy if the stock price is greater than 10 and forward PE ratio is less
than 15
Buy if Mkt Cap is better than 50.00 and return on assets is better than
6.00
Hold otherwise

Thanks!!

Excel Help!!
 

=IF(OR(AND(StockPrice10,PE_ratio<15),AND(Mkt_Cap 50,ReturnOnAssets6)),"Buy","Hold")

Le 2017-03-02 à 00:05, isabelle a écrit :
Hi,

Buy if the stock price is greater than 10 and forward PE ratio is less than 15
Is there an "OR" here?
Buy if Mkt Cap is better than 50.00 and return on assets is better than 6
Hold otherwise


isabelle

Le 2017-03-01 à 21:38, hayley_n2008 a écrit :
How would I write an excel formula using the following conditions? I
keep getting an error message and I dont know what I am doing wrong

Buy if the stock price is greater than 10 and forward PE ratio is less
than 15
Buy if Mkt Cap is better than 50.00 and return on assets is better than
6.00
Hold otherwise

Thanks!!