I need help with a IF formula, how to return a value and ignore rest of formula if a box is checked?
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?
Best Answer

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')
Answers

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')

This worked, thank you!
Help Article Resources
Categories
Check out the Formula Handbook template!