Help with Budget Health formula

Stephen Huff

I stink at formulas and am trying to calculate budget health. If my Budget is greater than my Actual, it's green. If my Budget is less than my Actual, it's red.

I'm using =IF([Budget]@Row > [Actual]@row, "Green", if [Budget]@Row < [Actual]@Row, "Red"))

How do I write this correctly?

Lidiya S.

Hello @Stephen Huff ,

Can you confirm for me if there is a "(" after the second IF statement? ( as shown below )

=IF([Budget]@Row > [Actual]@row, "Green", IF([Budget]@Row < [Actual]@Row, "Red"))

Also, what status would you want if the Budget = Actual? If you would want it to be green, the formula just need one symbol added ("=" next to ">"):

=IF([Budget]@Row >= [Actual]@row, "Green", IF([Budget]@Row < [Actual]@Row, "Red"))

Best,

Lidiya Shutaya

lidiya@ddbconsultants.ca

Lidiya S.

Hello @Stephen Huff ,

Can you confirm for me if there is a "(" after the second IF statement? ( as shown below )

=IF([Budget]@Row > [Actual]@row, "Green", IF([Budget]@Row < [Actual]@Row, "Red"))

Also, what status would you want if the Budget = Actual? If you would want it to be green, the formula just need one symbol added ("=" next to ">"):

=IF([Budget]@Row >= [Actual]@row, "Green", IF([Budget]@Row < [Actual]@Row, "Red"))

Best,

Lidiya Shutaya

lidiya@ddbconsultants.ca

Stephen Huff

Thank you! This works :-)