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

Shortcut Nested If Statements
 

=if(countif(A1:D1,"text")0,True,False)

or just

=countif(A1:D1,"text")0

--
Regards,
Tom Ogilvy


wrote in message
ups.com...
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