Refering to an empty cell
Does anybody know any way of having a cell refer to
another cell and actually be considered as a really empty cell if the refered cell is actually empty? i.e. A1 is actually empty and my cell A2 which is refering to A1 is considered just like A1. Thanks a lot |
Refering to an empty cell
I suppose if(a1="","",A1) -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=520857 |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com