Hi, how do you use a range for "Not", for range of items that might be blank?
getting #Div/0! & #Value! errors. Thanks..

#VALUE! Errors: (misused range?)
=IF(AL9:AN9=0),"",
=IF(AL9:AN9=""),"",
=IF((AL9:AN9)=""),"",