View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] rrstudio2@icqmail.com is offline
external usenet poster
 
Posts: 5
Default Shortcut Nested If Statements

Is there a shorter way to do this formula:
=if( or(a1="test",b1="test",c1="test",d1="test"),"true" ,"false" ) ?

Looking for something like
=if ( a1:d1 = "test", "true","false")

Thanks,
Andrew V. Romero