IF statement formular

[redlion]

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,C8<Criteria!H11,C22<Criteria!H18),"LLLLLL","")



Any help would be great

Thanks
Redlion

[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

[duane]

I have not opened your attached file = what are you trying to 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 all are

[redlion]

Thank you very much duane

[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 by 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 goes