Slight change needed to formula?

[Bob Vance]

--
=IF(DA96=0,"N / A",DA96*CY96)
how can I change this formula so if CY96 =0 that the cell remains blank
instead of showing N / A


Thanks in advance for your help....Bob Vance

 

[Don Guillett]

just surround your formula with
=if(cy96="","",rest of formula)
but that might not be the best answer.
maybe
=if(or(da90=0,cy96=""),"",da96*cy96)

 

[John Wilson]

Bob,

The simple answer to your question is:
=IF(CY96=0,"",(DA96=0,"N / A",DA96*CY96))

But I'm confused about what you're doing here....???
If either cell is zero, the result of the multiplication will be zero.
So....
IF(CY96*DY96=0,"",DA96*CY96)
Would work too, but it will only eliminate the "0" (replaced by a blank).
You could just use the simple formula:
=DA96*CY96
and use Tools/Options/View & uncheck zero values to get the
same result (zero's not displayed)

John

 

[John Wilson]

Bob,

Typo in previous post...
=IF(CY96=0,"",IF(DA96=0,"N / A",DA96*CY96))

John

 

[Bob Vance]

Thanks worked brilliantly




Thanks in advance for your help....Bob Vance