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!

Find more posts tagged with

Formulas

Comments

aqeelsidd

Woohoo, I answered my own question.

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

Matt Hagler

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.

Chris McKay

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

Sign in to join the conversation!

Quick Links

Trending discussions

Dynamic formula to return date of next Thursday every week.
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Check box for date in previous month
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?
Need Help with If, Index, Collect
Please help, I have a few of these to do. I have a nested IF formula. The first part is an INDEX/MATCH and works as a standalone. The next few are INDEX/COLLECT. These are not working as standalone or in the nested version (Unparsable Error). Any ideas? =IF(CONTAINS(“A/V”, [Vendor Type]@row ), INDEX(COLLECT({Date Secured…