View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
redlion redlion is offline
external usenet poster
 
Posts: 1
Default IF statement formular


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