Need a fix for IF AND/OR formula

keesuri25

IF(AND([Phase]@row = "COMPLETED”, OR Hand-off]@row = "N/A", [Hand-off]@row = 0),0,1)

So for Phase set to completed and where Hand-off is N/A or 0 or blank .. need to set 0, or else 1.

Or For Phase set to completed, where Hand-off is 1 - put 1.. for everything else put 0 ..

Mike TV

@keesuri25

=IF(AND(Phase@row="COMPLETED", [Hand-off]@row=1), 1, IF(AND(Phase@row="COMPLETED", OR([Hand-off]@row="N/A", [Hand-off]@row=0, ISBLANK([Hand-off]@row))), 0, 1)

This may or may not work because your first conditions you say "or else 1" and your second conditions you say "for everything else put 0". Very confusing.

Jeff Reisman

@keesuri25 You are close, just a little syntax fix and a bit more criteria needed.

IF(AND([Phase]@row = "COMPLETED”, OR([Hand-off]@row = "N/A", [Hand-off]@row = 0, ISBLANK([Hand-off]@row))), 0, 1)

Logic: If Phase equals COMPLETED and Hand-off is either "N/A", 0, or blank, set the cell to 0; otherwise, set the cell to 1. (The OR statement containing the options for Hand-off has to be enclosed within the AND statement.)