Help with Range...
thankyou..
"pinmaster" wrote:
Not sure what you're looking for but maybe:
=IF(COUNTA(AL9:AN9)=0,"",
HTH
JG
"nastech" wrote:
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)=""),"",
|