Don't formulate if blank. How?

**lordFRZA** · 08-23-2009, 05:55 PM

ok here is what I got:

I have a cell that adds up the money brought in ("Income") from several locations each entered in different cells in the column and added at the bottom with this formula:
=SUM(E22,E19,E18,E16,E14,E13,E11,E10,E8,E4) There is one of these for 3 days each week.

I also have a column that shows the amount of product taken to these locations and a column showing the amount of product returned to me from these locations, added at the bottom with a similar formula.

On another page I have a "weekly projected income" that adds the amounts taken for 1 week and subtracts it from the total returned for that same week then multiplies it by the price of the product, with this formula:
=IMSUB('DAILY TRACKER'!$F$23+'DAILY TRACKER'!$I$23+'DAILY TRACKER'!$L$23+'DAILY TRACKER'!$O$23,'DAILY TRACKER'!$G$23+'DAILY TRACKER'!$J$23+'DAILY TRACKER'!$M$23+'DAILY TRACKER'!$P$23)*0.75

then I have a "money lost to theft" tracker that subtracts the "income" from the "weekly projected income" with this formula:
=B5-C5

then I have a "number stolen" that takes the "money lost to theft" and divides it by the price of the product with this formula:
=E5/0.75

My Issue is:
Untill I get the returned product those cells remain blank. The blanks go into the formulas as zeros and causing the cells to report false theft numbers. They are very high. The more I think about this the more stressed it makes me. The only solution I can come up with (If it's even possible) is to stop the formulas when the blanks are in them.
Any way to do that? I am also open to any sugestions anyone might have.

**martindwilson** · 08-23-2009, 06:40 PM

you can wrap the formula up in isblank()
if(isblank(some cell ),"do nothing",do this formula)

**lordFRZA** · 08-23-2009, 10:50 PM

I like that formula. It works great on my first page. But now, what if I want the "blank" to be $0.00? like this:
=if(is$0.00(C4),"$0.00",B4-C4)
I know this does not work. How do I get it to work?