bLANK cELL
 

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

bLANK cELL
 

=IF(AW570*G570=0,"",AW570*G570)
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"shawnews" wrote:

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

bLANK cELL
 

In <xkmui.43718$rX4.24014@pd7urf2no, shawnews spake
thusly:

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=