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