Slight change needed to formula?

  • Thread starter Thread starter Bob Vance
  • Start date Start date
B

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