Thank you that was very helpful is there another bit I can add onto this to ignore 0 ?You could nest an IF function, i.e.
Excel Formula:=IF(AC4="","",IF(AC4<=10,"within timescales","outwith timescales"))
Sure, just add an OR clause to the first IF, i.e.Thank you that was very helpful is there another bit I can add onto this to ignore 0 ?
=IF(OR(AC4=0,AC4=""),"",IF(AC4<=10,"within timescales","outwith timescales"))
=IF(AC4=0,"",IF(AC4<=10,"within timescales","outwith timescales"))