Multle IF statements in a spreadsheet

Hi jrmac,

Welcome to the forum.


You can with the AND/OR function. Like the below

If you want all conditions to be met then use the AND Function

 =IF(AND(A1=0,B1=0,C1=0,D1=0),"Active"," - ")

If you want any1 condition to be met then use the OR Function

=IF(OR(A1=0,B1=0,C1=0,D1=0),"Active"," - ")

Thanks,

Bonny Tycoon


**If I was able to help please click the small star icon at the bottom left of my post **