% Time Elapsed Formula - Help breaking down and understanding long nested formula

AndyM

oops, I pasted the test version with VAR1 VAR2 above, don't use that one, ;-), here's the correct version:

=IFERROR(IF(AND(OR([% Time Elapsed]@row = 0, [% Time Elapsed]@row = ""), OR([% Complete]@row = 0, [% Complete]@row = "")), "Gray", IF(AND(OR([% Time Elapsed]@row = 0, [% Time Elapsed]@row = ""), [% Complete]@row > 0), "Green", IF([% Time Elapsed]@row - [% Complete]@row < 0.1, "Green", IF([% Complete]@row = 1, "", IF(AND(ISDATE([End Date]@row), [End Date]@row < TODAY(), [% Complete]@row < 1), "Red", IF(AND(ISDATE([Start Date]@row), [Start Date]@row <= TODAY(), [% Complete]@row < 0.01), "Red", IF(AND([% Time Elapsed]@row <> "", [% Complete]@row <> "", ([% Time Elapsed]@row - [% Complete]@row >= 0.1)), "Yellow", IF([% Complete]@row = 0, "Gray", "Green")))))))), "Formula Error")