Seems to give all blanks. What about using AND(ISBLANK(cell), ISBLANK....)

"Fred Smith" wrote:

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.