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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.7K Get Help
 405 Global Discussions
 216 Industry Talk
 456 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!