LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to represent an empty cell in excel formulae?

The formula should work only when the cell has some value and should not take
the emptyness as zero value. Is there a way where by an empty cell can be
represented or is there any other way to activate the formula only when cell
has some value.
 
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
find the cells that represent a code in one cell shane Excel Worksheet Functions 1 July 29th 08 06:21 PM
How do I get a number or letter to represent cell contents? Formula help Excel Discussion (Misc queries) 2 February 25th 06 11:51 PM
What does the 8.43 and 12.75 represent in height and width of cell ljfrantz40 Excel Discussion (Misc queries) 2 October 17th 05 02:25 AM
How to represent an empty cell in excel formulae? Sibi Melvin Excel Worksheet Functions 1 June 23rd 05 08:18 AM
How do I represent data in a cell as hexadecimal without converti. trosier Excel Discussion (Misc queries) 1 December 23rd 04 02:47 PM


All times are GMT +1. The time now is 09:06 PM.

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"