Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SQL concatenation statement | Excel Discussion (Misc queries) | |||
SET statement tutorial | Excel Discussion (Misc queries) | |||
If statement | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
IF Statement | New Users to Excel |