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!
Comments

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
Categories
Check out the Formula Handbook template!