Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 48
Default isBlank()

Hello experts,

I'm trying to use the isBlank() function to in one cell to reference
another directly to the right.

Problem is, however, that said cell to the right, while holding a null
value, also has a formula causing the isBlank function to return
false.

Is there a function that will return true if the cell is empty and has
an associated formula?

Thanks for the time,
alex

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumif & Isblank briank Excel Worksheet Functions 3 July 31st 06 02:11 PM
ISBLANK returns flase when there is nothing in the cell referenced cugrngneer Excel Discussion (Misc queries) 5 April 25th 06 10:26 PM
ISBLANK Formula Help Request John C. Harris, MPA Excel Worksheet Functions 4 July 22nd 05 10:06 PM
VLOOKUP & ISBLANK P08254 About this forum 0 May 27th 05 04:21 AM
Is there a function for "not isblank" (find a cell that has a val. Jim Excel Worksheet Functions 3 December 8th 04 07:29 AM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"