If statement

[xxsalahxx]

Hello I’m trying to do an if statement and it is working however I want it to skip blank cells the column is there a way I can do this?

Any help I’d appreciate
=IF(AC4<=10,”within timescales”,”outwith timescales”)

 

[Joe4]

You could nest an IF function, i.e.

=IF(AC4="","",IF(AC4<=10,"within timescales","outwith timescales"))

 

[xxsalahxx]

You could nest an IF function, i.e.

=IF(AC4="","",IF(AC4<=10,"within timescales","outwith timescales"))

Thank you that was very helpful is there another bit I can add onto this to ignore 0 ?

 

[Joe4]

Thank you that was very helpful is there another bit I can add onto this to ignore 0 ?

Sure, just add an OR clause to the first IF, i.e.

=IF(OR(AC4=0,AC4=""),"",IF(AC4<=10,"within timescales","outwith timescales"))

Since blank usually evaluates to zero, you may even be able to eliminate the check for blank, and just check for 0, i.e.

=IF(AC4=0,"",IF(AC4<=10,"within timescales","outwith timescales"))