ExcelBanter - Help with Range...

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Help with Range... (https://www.excelbanter.com/excel-discussion-misc-queries/64597-help-range.html)

nastech

Help with Range...

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)=""),"",

pinmaster

Help with Range...

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)=""),"",

nastech

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)=""),"",

pinmaster

Help with Range...

You're welcome, and thanks for the feedback!

Regards
JG

"nastech" wrote:

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)=""),"",

All times are GMT +1. The time now is 02:34 AM.