| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Small macro
In A8:A24, I have formula's, the result of which produces
numbers(dollar amounts), text and blanks in the range. How can I create a macro that inserts TRUE in cells AD8:AD24 if cells A8:A24 contain a number and FALSE if they do not. Thankyou |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Small macro
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Small macro
-----Original Message----- In A8:A24, I have formula's, the result of which produces numbers(dollar amounts), text and blanks in the range. How can I create a macro that inserts TRUE in cells AD8:AD24 if cells A8:A24 contain a number and FALSE if they do not. Thankyou . You can use a simple function in the cell you want True or False to appear in. =IF(A8 0,True,False) and copy the formula down the whole range of AD8:AD24. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SMALL IF | Excel Discussion (Misc queries) | |||
| ISERROR,SMALL,INDEX, MATCH, SMALL?? | Excel Discussion (Misc queries) | |||
| Using Small | Excel Worksheet Functions | |||
| Small | Excel Discussion (Misc queries) | |||
| Newbee needs HELP-Small Macro | Excel Discussion (Misc queries) | |||
Hybrid Mode
