Baselines & Variance If Formula

Samuel15

I have created a new Health column and I'm trying to use the Variance number from the baseline to reflect the following.

0 Variance = "On Track", > 0 Variance = "Ahead", < 0 = Behind Schedule.

=IF([Variance]@row = 0, "On Track", IF([Variance]@row< 0(), "Behind Schedule", IF([Variance]@row> 0, "Ahead")))

Can someone help me correct the formula please.

Thank You

Sam

Nic Larsen

Looks like a couple extra brackets.

=IF([Variance]@row = 0, "On Track", IF([Variance]@row < 0, "Behind Schedule", IF([Variance]@row > 0, "Ahead"

Nic Larsen

Looks like a couple extra brackets.

=IF([Variance]@row = 0, "On Track", IF([Variance]@row < 0, "Behind Schedule", IF([Variance]@row > 0, "Ahead"

Samuel15

Yep…Thanks Nic !