bLANK cELL

[shawnews]

I'm trying to use the formula ( below) to display a blank cell if there is
no value or the cell is blank
it displays 0 in the resulting cell
Any help appreciated.

Roger

=IF(ISERROR(AW570*G570)," ",(AW570*G570))

 

[Guest]

=IF(AW570*G570=0,"",AW570*G570)

 

[Dallman Ross]

I'm trying to use the formula ( below) to display a blank cell
if there is no value or the cell is blank it displays 0 in the
resulting cell Any help appreciated.

=IF(ISERROR(AW570*G570)," ",(AW570*G570))

Well, if the cells are blank then it's not an error, is why.
It sounds like maybe you want this:

=IF(OR(ISERROR(AW570*G570),AW570*G570=0),"",(AW570*G570))

=dman=