Try this nested IF IF((FieldA<0),"Ahead", IF((FieldA<8),"Within 1 Week", "Over 1 week")) The Basic Format of an IF is below, so nesting a second IF in the False Statement creates a more traditional chained IF else: IF(Condition, TRUE Statement, FALSE Statement) You should only need to bracket your F...