| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
errors in worksheet functions
I have 3 worksheet fuctions that show errors eg:
=AVERAGE(LARGE(Z32:Z36,{1,2,3,4,5})) returns #NUM! when cell "Z" is blank =SMALL(AE32:AE300,2) returns #NUM! when cell "AE" is blank =VLOOKUP(AH39,AE32:AG300,3,FALSE) returns #NUM! when cells "AH" contains #NUM! ,"AE" is blank , "AG" is a number (2) can some one tell me how to turn #NUM! into a blank cell ? Please. Thank you all regards bill gras -- bill gras |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to get the complete list Excel Worksheet Functions | Excel Worksheet Functions | |||
| Worksheet Memory hog | Excel Discussion (Misc queries) | |||
| Refrencing another cell in a worksheet that "could" exist | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| worksheet functions with dates | Excel Worksheet Functions | |||
Threaded Mode
