|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 11th, 2006, 09:31 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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)=""),"", 
|
|
#2
January 11th, 2006, 09:41 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)=""),"",
|
|
#3
January 11th, 2006, 10:01 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)=""),"",
|
|
#4
January 11th, 2006, 10:06 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)=""),"",
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Data Validation range | Nigel | General Discussion | 2 | December 15th, 2005 10:33 AM |
| Question about using Find with a Range object | Max Moor | Formatting Long Documents | 11 | May 16th, 2005 04:47 PM |
| Data Range | Patrik Karlstrom | Worksheet Functions | 2 | October 4th, 2004 04:54 PM |
| Formulas with named ranges with 2 or more range areas | agarwaldvk | Worksheet Functions | 1 | September 7th, 2004 07:33 AM |
| is there a formula that can count a range of cells with text? | Frank Kabel | Worksheet Functions | 0 | March 11th, 2004 08:04 PM |
Linear Mode
