either, or (if or formula) help needed!

[fahadferoz]

The customer might own motorcycle, turck or rv. If yes then the next cell will be 0. or else will be 1.

Please have a look at the tiny attached spreadsheet.

Thanks for your help!

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Syedali]

Hi,

=IF(AND(A3=0,B3=0,C3=0),1,0)

 

[Hui]

D3: =1*NOT(MAX(A3:C3))
copy down

 

[bosco_yip]

D3 :

=-(A3&B3&C3)

And, custom cell format: ;\0;1

Copy down

Regards