#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Blank if zero

Hi,
I'm wondering if there is a function similar to "iferror" that will leave a cell blank if the result of its formula equals zero. I normally do something like:

if(A1-A20, A1-A2, "")

This gets tedious and difficult to follow with long and/or nested formulas, so I'm looking for a shortcut. Does such a thing exist?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default Blank if zero

Hi Weston,

Am Thu, 1 Oct 2020 13:21:58 -0700 (PDT) schrieb Weston Cook:

Hi,
I'm wondering if there is a function similar to "iferror" that will leave a cell blank if the result of its formula equals zero. I normally do something like:

if(A1-A20, A1-A2, "")

This gets tedious and difficult to follow with long and/or nested formulas, so I'm looking for a shortcut. Does such a thing exist?


Options = Advanced = Display options for this worksheet and
deactivate "Show a zero in cells that have zero value"


Regards
Claus B.
--
Windows10
Office 2016
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
Index/match - make blank cells return a blank value. diaare Excel Worksheet Functions 3 May 3rd 23 03:44 AM
Need Array Formula for Counting Blank & Non Blank Cells (Multiple Criteria) foofoo Excel Discussion (Misc queries) 3 February 20th 12 09:03 PM
Average Formula to display blank cell if named range is blank Rachael F Excel Worksheet Functions 3 February 22nd 08 06:05 PM
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... [email protected][_2_] Excel Programming 2 June 7th 07 09:27 PM
Not showing blank and non blank items in filter mode for values Bhaskar Polisetty Excel Worksheet Functions 0 June 20th 06 02:04 PM


All times are GMT +1. The time now is 01:30 PM.

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

About Us

"It's about Microsoft Excel"