Problems figuring out nested-IF formula

Chad Meacham

I'm having difficulty figuring out what is wrong with my formula in attempting to use a nested-if formula to automate the RYG light in the "Status" column, depending on the "% Complete" column.

Here is my formula: 

=IF([% Complete]3 < 0.7, "Red", IF(AND([% Complete]3 => 0.7, "Yellow, [% Complete]3 < 1.0, "Yellow", IF([% Complete]3 = 1.0, "Green")))

Can anyone assist? Thanks,

Chad

Mike Wilday

I think the primary issue is your => it should be >= 

=IF([% Complete]3 < 0.7, "Red", IF(AND([% Complete]3  >= 0.7, "Yellow, [% Complete]3 < 1.0, "Yellow", IF([% Complete]3 = 1.0, "Green")))

Try this rendition.

Chad Meacham

I appreciate the quick assist Mike. I put your rendition in and still not coming out. That adjustment does make sense though. If you think of anything else I'd gladly take the recommendation. Thank you!

 

Andrée Starå

Hi Chad,

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Mike Wilday

Oh! The AND statement wasn't formatted correctly either. Totally missed it! Try this one. 

=IF([% Complete]3 < 0.7, "Red", IF(AND([% Complete]3  >= 0.7, [% Complete]3 < 1), "Yellow", IF([% Complete]3 = 1, "Green")))

Chad Meacham

Brilliant! Thank you sir, that was it. Greatly appreciated. Have yourself a wonderful weekend!

Chad

Mike Wilday

Awesome! Glad I could help you figure it out!!!