Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 200

Zero's

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Zero's	Bar Charts With =sum ... showing Zero	Charts and Charting in Excel	1	December 7th 06 07:02 PM
Zero's # 2	Delaina	Excel Discussion (Misc queries)	3	October 24th 05 08:02 PM
Zero's	Delaina	Excel Discussion (Misc queries)	2	October 20th 05 06:38 PM
Leading zero's	elwyn	Excel Discussion (Misc queries)	1	August 14th 05 12:37 AM
Zero's	Krandall	New Users to Excel	1	June 9th 05 08:11 PM

All times are GMT +1. The time now is 07:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us