| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
