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

[aff219]

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,"")

[jeffreybrown]

In order to get the best help possible, the first step would be to follow the forum rules and word your title properly.

Second, can you attach a small sample workbook with what you are trying to achieve.

[jeffreybrown]

For reference, the one I've made work properly and cleanly is this:
=IF(D11>0,(D11*0.029)+0.3,"")

So if this works, what exactly is the question? It looks fine.

[aff219]

So if this works, what exactly is the question? It looks fine.

that works in a different section (that entire quoted item is a different formula then what i stated the problem with). when applying the same idea to the original formula, it doesnt work, and i cant figure out why

[jeffreybrown]

I suppose there are many ways to solve certain problems, but a few suggestions...

Maybe change the formula to

Please Login or Register  to view this content.

or in Excel Options under Display options for the worksheet

Uncheck >> Show a zero in cells that have a zero value

or set a custom format to hide the zero

0;;;@