Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 4th 05, 11:53 PM
pherozeb
 
Posts: n/a
Default display negative values as a blank cell in Excel

Could someone please tell me how to display negative values calculated from a
formula as a blank cell in Excel

  #2   Report Post  
Old January 5th 05, 12:01 AM
Max
 
Posts: n/a
Default

Try something like:

=IF(A1+A2<0,"",A1+A2)

Replace "A1+A2" with your formula
--
Rgds
Max
xl 97
---
GMT+8, 1 22' N 103 45' E
xdemechanik <atyahoo<dotcom
----
"pherozeb" wrote in message
...
Could someone please tell me how to display negative values calculated

from a
formula as a blank cell in Excel



  #3   Report Post  
Old January 5th 05, 01:09 AM
Dave Peterson
 
Posts: n/a
Default

=if(yourformula<0,"",yourformula)



pherozeb wrote:

Could someone please tell me how to display negative values calculated from a
formula as a blank cell in Excel


--

Dave Peterson
  #4   Report Post  
Old January 5th 05, 05:40 AM
Earl Kiosterud
 
Posts: n/a
Default

zeb,

If you only want it displayed as blank, retaining the value in the cell,
format the cell (Format - Cells - Number - Custom):

General;;General

Change the first General to any format code you want for positive numbers
(0.00, etc), and the other General for how you want zero values displayed.



--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"pherozeb" wrote in message
...
Could someone please tell me how to display negative values calculated
from a
formula as a blank cell in Excel





Reply
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 negative values as a blank cell in Excel Pheroze Bharucha Excel Discussion (Misc queries) 0 January 4th 05 11:51 PM
Can you reference cell values in Headers and Footers in Excel 200. jkyte Excel Discussion (Misc queries) 2 December 30th 04 10:05 PM
How to display cell values in wordarts? Anderson Lee Excel Discussion (Misc queries) 2 December 28th 04 04:05 PM
Display a pix from a URL in a Excel cell Pilot007 Excel Discussion (Misc queries) 1 December 27th 04 01:22 AM
Using Jet to read excel file returns blank for last cell - sometim Ron Excel Discussion (Misc queries) 1 December 9th 04 09:21 AM


All times are GMT +1. The time now is 03:07 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017