Zero's

  • Thread starter Thread starter PAL
  • Start date Start date
P

PAL

I have this formula that works very well.

=IF(ISBLANK(E297),IF(ISBLANK(C297),TEXT((D297-B297)/30.43,"#.0")&"
(Plan-Plan)",TEXT((D297-C297)/30.43,"#.0")&"
(Actual-Plan)"),TEXT((E297-C297)/30.43,"#.0")&" (Actual-Actual)")

Problem is that many of the rows, do not have any values, and thus the
formula yields "0.0 text".

Is there a way to change this so when there is a 0 it returns a blank.
 
I'd check for it first. Something like:
=if(count(yourrange)=0,"",
IF(ISBLANK(E297),IF(ISBLANK(C297),TEXT((D297-B297)/30.43,"#.0")&"
(Plan-Plan)",TEXT((D297-C297)/30.43,"#.0")&"
(Actual-Plan)"),TEXT((E297-C297)/30.43,"#.0")&" (Actual-Actual)"))

Regards,
Fred
 
Back
Top