Posted to microsoft.public.excel.programming

Mangawy

external usenet poster

Posts: 1

what is the formula that help when cell=0/cell=0 to be display a .

at the excel if b1 = 0 , b2 = 0 , and b3 formula is =(b1)/sum(b1:b2) it
display at b3 " #div/0!" i need a formula replace " #div/0!" at b3 with
number "100"
please help

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
Display formula on the cell	journey	Excel Worksheet Functions	2	August 27th 09 11:23 AM
Display cell ref for MAX formula	bookman3	Excel Discussion (Misc queries)	7	October 17th 08 06:31 AM
Formula won't display as cell set to Constant	Laurence J	Excel Discussion (Misc queries)	1	June 14th 07 11:42 AM
Display formula in cell	Trish	Excel Discussion (Misc queries)	1	May 13th 05 09:14 AM
Shortcut key to display change the display from displaying cell values to cell formulae	Adrian[_7_]	Excel Programming	3	September 14th 04 12:07 PM

All times are GMT +1. The time now is 07:46 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us