Hello,

Hi Guys,

The attached spreadsheet is used to assess if we will invest in certain
companies.

I have tried the following IF statement but it does not work.

=IF(OR(C19=Criteria!H4,C8Criteria!H11,C22Criteri a!H18),"","LLLLLL")

With the First statment (C19+Criteria!H4) how do I tell it if it = C19
and C19



Any help would be great

Thanks
Redlion


+-------------------------------------------------------------------+
|Filename: raitotest5.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5040 |
+-------------------------------------------------------------------+

--
redlion
------------------------------------------------------------------------
redlion's Profile: http://www.excelforum.com/member.php...o&userid=36140
View this thread: http://www.excelforum.com/showthread...hreadid=561904

if you mean greater than or equal to

if(C19=Criteria!H4......


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=561904

Hi duane,

I can't seem to get it to work, am I using the right IF Statement?



regards
Redlion


+-------------------------------------------------------------------+
|Filename: raitotest5.zip |
|Download: http://www.excelforum.com/attachment.php?postid=5041 |
+-------------------------------------------------------------------+

--
redlion
------------------------------------------------------------------------
redlion's Profile: http://www.excelforum.com/member.php...o&userid=36140
View this thread: http://www.excelforum.com/showthread...hreadid=561904

I have not opened your attached file = what are you trying to
accomplish?


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=561904

I have some Investment Criteria that must be meet if I am to invest in
them.

the following must be meet to Invest

Current Ration must be at least 1
Return on Shareholders funds exceeds 15% and
Dividend Yield exceeds 4.5%

I would like an IF statment to tell me if any of these are not meet.


--
redlion
------------------------------------------------------------------------
redlion's Profile: http://www.excelforum.com/member.php...o&userid=36140
View this thread: http://www.excelforum.com/showthread...hreadid=561904

assuming your cell references are correct

=IF(OR(C19<Criteria!H4,C8<Criteria!H11,C22<Criteri a!H18),"LLLLLL","")

would appear to return LLLLLL if any criteria not met, and "" if all
are


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=561904

Thank you very much duane


--
redlion
------------------------------------------------------------------------
redlion's Profile: http://www.excelforum.com/member.php...o&userid=36140
View this thread: http://www.excelforum.com/showthread...hreadid=561904

Try Something like this
=IF(AND(C19=Criteria!H4,C8Criteria!H11,C22=Crit eria!H18),"","LLLLLL")

If the below values are always the same you could simplify matters by
putting
=IF(AND(C19=1,C815,C224.5),"","LLLLLL")
Current Ration must be at least 1
Return on Shareholders funds exceeds 15% and
Dividend Yield exceeds 4.5%

let me know how it goes


--
Steel Monkey
------------------------------------------------------------------------
Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051
View this thread: http://www.excelforum.com/showthread...hreadid=561904