Formula

aleja

Hi all,

I am trying to combine the following two formulas, only one works at a time.

=IF([Variance (Target End date)]@row = 0, "Green", IF([Variance (Target End date)]@row <= -4, "Red", IF(OR([Variance (Target End date)]@row = -1, [Variance (Target End date)]@row = -2, [Variance (Target End date)]@row = -3), "Yellow", "Green")))

=IF([Status]@row = "Complete", "Blue"

Best,

Alejandra

Paul Newcome

You would put the one reading Status as the first in the string of the nested IFs.

Paul Newcome

You would put the one reading Status as the first in the string of the nested IFs.

aleja

I tried that but I get #INCORRECTARGUMENT SET. I used the following:

=IF([Status]@row = "Complete", "Blue", [Variance (Target End date)]@row = 0, "Green", IF([Variance (Target End date)]@row <= -4, "Red", IF(OR([Variance (Target End date)]@row = -1, [Variance (Target End date)]@row = -2, [Variance (Target End date)]@row = -3), "Yellow", "Green")))

Paul Newcome

You forgot your IF( after you finish off the first "Blue".