Zero's
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
"PAL" wrote in message
...
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.
|