| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selective cell changes
Instead of
=IF(Y2="","",IF(Y20,"active",Y2)) you could use: =IF(Y2="","NULL",IF(Y20,"active",Y2)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Colin Hayes" wrote in message ... Max I've just had a little extra problem. Could I use your formula to replace cells in the column with no content to read 'NULL' , with cells having content remaining the same? Best Wishes Colin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selective concatenation using VBA | Excel Worksheet Functions | |||
| Selective addition | Excel Worksheet Functions | |||
| Selective calculation | Excel Worksheet Functions | |||
| selective autofill with functions | Excel Worksheet Functions | |||
| selective averaging | Excel Worksheet Functions | |||
Hybrid Mode
