Thread
:
Shortcut Nested If Statements
View Single Post
#
1
Posted to microsoft.public.excel.programming
[email protected]
external usenet poster
Posts: 5
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
Reply With Quote
[email protected]
View Public Profile
Find all posts by
[email protected]