I need help with a IF formula, how to return a value and ignore rest of formula if a box is checked?

Amy Merrill

I have a formula started in the Day 1 Delay column to return various values if the duration of delay is between certain numbers however, if the on hold or cancelled columns are checked. I'd like a value to be returned, I'm assuming it would need to ignore the formula is the box is checked and only return "On hold" or "Cancelled" in the Day 1 delay column. Thoughts on a formula?

JamesB

@Amy Merrill

Since the Cancelled or On Hold columns are the first consideration in your statement, start your if off with this check.

If(OR(Cancelled@row=1,[On Hold]@row=1),'Your Value if True', 'Your Formula here if False')

JamesB

@Amy Merrill

Since the Cancelled or On Hold columns are the first consideration in your statement, start your if off with this check.

If(OR(Cancelled@row=1,[On Hold]@row=1),'Your Value if True', 'Your Formula here if False')

Amy Merrill

This worked, thank you!