Excel spreadsheet Column H figures 55 percent of Column G. I want Column H to be empty if Column G is empty?

Question

Here is the function I'm using in column H: =PRODUCT(G4,0.55) Right now, if the cell in column G is empty, column H displays ".55" I want column H to be blank and display nothing unless there is a value in column G. How do I do this?

Answer 1

put an IF statemet to check for blank first

in your cell in H1 (or where ever) , enter

=IF(ISBLANK(G4), "", PRODUCT(G4,0.55))

if G4 is blank, then H1 will be blank, otherwise H1 will do your formula

Answer 2

Make your formula in H "IF(G4=" "," ",PRODUCT(G4,0.55))".  This is what's called an "if-then-else" formula.  It says "If G4 is blank, then make the cell where this formula is (H4) blank, else if G4 is not blank, multiply the value in G4 by 0.55."