negative numbers

[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!

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[PeterM]

aw geezzz...that was so simple, thank you

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

--


Regards,


Peo Sjoblom

 

[Gregory A Greenman]

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!

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);"