IF statement formular

[redlion]

Hello,

Hi Guys,

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

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

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

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



Any help would be great

Thanks
Redlio

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

 

[duane]

if you mean greater than or equal to

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

 

[redlion]

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 |
+-------------------------------------------------------------------+

 

[duane]

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

 

[redlion]

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.

 

[duane]

assuming your cell references are correct

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

would appear to return LLLLLL if any criteria not met, and "" if al
ar

 

[redlion]

Thank you very much duan

 

[Steel Monkey]

Try Something like this
=IF(AND(C19>=Criteria!H4,C8>Criteria!H11,C22>=Criteria!H18),"","LLLLLL")

If the below values are always the same you could simplify matters b
putting
=IF(AND(C19>=1,C8>15,C22>4.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 goe