0

I have 6 columns and 3 equations : E*F=G, H*G=I & G+I=J

I don't want zeros to print if a cell in F or H is empty.

Currently I have these equations and everything is dependent on the F & H Cell:

column G: IF(ISBLANK(F22),"",E22*F22)

Column I: IF(ISBLANK(H22),"",H22*G22)

Column J: IF(ISBLANK(F22),K22,G22)+IF(H22>0,+I22) Where K22 is an empty cell.

without using K, the result was #Value! if F is blank.

How do I get nothing to print in Column J if cells in Column F are empty.
Presently "zeros" print in Column J.

DavidPostill
  • 162,382
Betty
  • 1

2 Answers2

2

Your problem is that the cells aren't blank. The cells are "" which we see as blank because it is an empty text string but is not actually blank. That leads to silliness like 0 + "" in your formula for J.

To fix the I formula, try this: IF(ISBLANK(H22),"",IF(ISBLANK(F22),"",H22*G22))

I'm not sure what you're trying to accomplish in J though. It looks like you forgot part of the formula (see that last bit IF(H22>0,+I22)?)

Tim
  • 204
1

I'm not clear what you want.  You say,

I don't want zeros to print if a cell in F or H is empty.

Based on that, it seems to me that you want to have

=IF(OR(ISBLANK(F22),ISBLANK(H22)), "", G22+I22)

in J22.  See also Display Blank when Referencing Blank Cell in Excel 2010 for other approaches.

Community
  • 1
Scott - Слава Україні
  • 22,532