negative numbers

  • Thread starter Thread starter PeterM
  • Start date Start date
P

PeterM

I have a problem with negative numbers and =If statements.
I have the following formula in a cell...

=IF(H28>"",H28*12,"")

if the value in H28 is greater than zero, it works fine, if the value in H28
is a negative number, it displays blank, if the value in H28 is zero, it
dsplays blank...

What I need is for the cell containing the formula to be blank if nothing is
in H28, or a positive or negative number if a positive or negative number is
in cell H28. What am I doing wrong?

thanks in advance for your help!
 
I have a problem with negative numbers and =If statements.
I have the following formula in a cell...

=IF(H28>"",H28*12,"")

if the value in H28 is greater than zero, it works fine, if the value in H28
is a negative number, it displays blank, if the value in H28 is zero, it
dsplays blank...

What I need is for the cell containing the formula to be blank if nothing is
in H28, or a positive or negative number if a positive or negative number is
in cell H28. What am I doing wrong?

thanks in advance for your help!
Click to expand...


Another way to do this, assuming you merely want the cell to appear
blank, is to simply make your formula "=h28*12" and then format the
cell so that zeros do not appear:

Format -> Cell -> Custom -> "#,##0_);(#,##0);"
 
Back
Top