# Formula Help

Hi,

I am trying to combine two formulas into one, both, are correct on their own but I am unsure on how to combine them.

Formula1: =IF([% Complete]7 < ABS(0.6), "High", "Low")

Formula2: =IF(Blocked7 = 1, "High", "Low")

So, if either of the "BOLD" conditions above are satisfied, then I would want the true/false values to return in the formula cell.

Thank you!

Tags:

• Woohoo, I answered my own question.

Solution: =IF(OR(([% Complete]7 < ABS(0.6)), Blocked7), "High", "Low")

• try this

=if(or([% Complete]<ABS(0.6),Blocked7=1),"high","low")

I'm not sure what the ABS cell is representing, but just make sure that your <,>,= symbols are used correctly in the formula.

• Hi all,

Respectfully, I'd go with:

=IF(OR([% Complete]<0.6,Blocked7),"Hi","Low")

You don't need to specify criteria when referencing checkboxes in an IF statement and the ABS is doing nothing at all because you're already specifying a positive value. You'd only use ABS if you were referencing a value that could be + or - and you wanted to deal with the value as an absolute (i.e. positive) number.

Cheers,

Chris

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!