LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kim Kim is offline
external usenet poster
 
Posts: 284
Default Cells display nothing IF

I have a row of cells linked to a formula where one cell plus or minus
another cell equals a value. The value I have displays as a negative number
because many of the cells are not populated at this point. This causes
confusion to other users. Is there a way to set the cells so that if the
value is less than 0 nothing is displayed in the cell?
 
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
Display cells when box is checked Mon Excel Discussion (Misc queries) 3 November 25th 05 09:05 PM
Display only certain cells ringersoll Excel Worksheet Functions 2 October 20th 05 08:19 PM
How can I conditionally add up cells and display? Marty Excel Discussion (Misc queries) 1 September 15th 05 06:41 PM
Formula cells needs to display "zero" hello Excel Discussion (Misc queries) 1 September 8th 05 05:51 AM
Display empty cells botany_girl Excel Discussion (Misc queries) 7 July 19th 05 06:40 PM


All times are GMT +1. The time now is 07:00 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"