Hi,

I tried to amend a formula to add an additional rule but I must have it wrong as it's not returning the value I expect.

This is the original formula which works fine:

=IF(AC5>45,"",IF(AC5>29,"Must",IF(AC5>19,"Should",IF(AC5>9,"Could",IF(AC5>=0,"Will Not")))))

This is the amended formula:

=IF(AC4>45,"",IF(AC4>29,"Must",IF(AC4>19,"Should",IF(AC4>9,"Could",IF(AC4>=0,"Will Not",IF(AC4=Legal or Fiscal,"Must"))))))

Thank you