Results 1 to 5 of 5

Excel 2007 : How to make Zero read blank in multi IF formula

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2011
    Location
    texas
    MS-Off Ver
    Excel 2003
    Posts
    28

    How to make Zero read blank in multi IF formula

    I've ALMOST got this how I want it...

    My goal was for it to give me the value of the forumla (WORKING), and if there is currently no value of the item ie 0, to read blank (NOT WORKING)

    Original Formula:
    =IF(D11>0,(D11*0.09)+0.1,)+IF(I11>0,0.5, )+IF(J11>0,0.1,)

    this allowed it to do the math properly, but if the result was 0, it read as $0.00 instead of blank.

    I was able to fix it so it DID leave a blank if the result was 0 with this:
    =IF(IF(D11>0,(D11*0.029)+0.3,"")=0,"",IF(D11>0,(D11*0.029)+0.3,""))

    however, something tells me I've made this much more difficult than it needs to be.

    I had to do a similar IF formula for another area, and I was able to make it read blank simply by putting the "else" value (sorry, i'm more of a programing junkythan an excel junky, i find it odd that "if then else" is replaced by "if , ,") to "" or " " but it doesnt seem to work in this one and im not sure why

    NOTE: I -think- the reason is because it contains multiple IF statements being added together, so its reading "blank + blank + blank" and deciding that value is $0.00, so my revision told it if that final value was 0, to label it "" ie blank...but I dont know how to clean it up any better and it looks uber sloppy

    For reference, the one I've made work properly and cleanly is this:
    =IF(D11>0,(D11*0.029)+0.3,"")
    Last edited by aff219; 10-18-2011 at 07:40 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1