Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-31-2018, 02:16 AM
Mihai Vultureanu Mihai Vultureanu is offline Empty cells with formulas Windows 7 64bit Empty cells with formulas Office 2013
Novice
Empty cells with formulas
 
Join Date: Jan 2018
Posts: 1
Mihai Vultureanu is on a distinguished road
Question Empty cells with formulas

Example:
In column D I have a formula like: if(column C >0;hello;"").
But, unfortunately, although the cells seem to be empty actually excell does'nt treat them as empty. Example: if you select the column from first cell to the last one with contains and you do it by pressing ctrl+shift+down arrow, your empty cells will be also selected.
So: do you have a solution in order to treat empty with formulas cells as though they are really empty?

Thank you,
Mihai Vultureanu
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert Row with Command Button Include Formulas and Merged Cells TileGal Excel Programming 12 08-30-2017 06:15 AM
Averaging cells with formulas petale Excel 2 08-10-2016 09:44 PM
Copying text range of cells to different cells adds an extra line jpb103 Word VBA 2 07-23-2014 12:22 PM
Empty cells with formulas how to transfer multiple excel cells into specific place in word document by formulas anton Excel 1 12-20-2011 03:56 AM
Empty cells with formulas How to transfer multiple cells from excel to word by formulas justziggy Word 5 05-23-2009 02:33 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:44 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft