MrExcel Publishing
Your One Stop for Excel Tips & Solutions

IF Statement


Posted by Paul Walton USAF on December 17, 2001 7:05 AM

Need Help....

If Cell A4 = ABC or DCS or GRS or RTQ, if true then D4 + F4, if false then ""

Can this be done?

Thanks in advance

Paul


Posted by Mark W. on December 17, 2001 7:14 AM

=IF(OR(A4={"ABC","DCS","GRS","RTQ"}),D4+F4,"")

Posted by Paul Walton USAF on December 17, 2001 7:21 AM

Thanks you
Paul