LMB

Posts: n/a

Want the cell blank

Hi Guys,

Using Excel 2000. I have a formula below. If the cells D41 and E41 are
blank, it returns this #DIV/0! I would like the cell to be blank if there
is no info in it. How do I do that?

=D41/E41

Thanks,
Linda

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
Empty Cell ( blank Cell )	rocky	Excel Worksheet Functions	2	April 28th 05 11:17 PM
Look for change next blank cell in Range	Nigel Bennett	Excel Worksheet Functions	1	March 13th 05 09:45 PM
Go to first blank cell	Curt D.	Excel Worksheet Functions	4	February 28th 05 10:27 AM
Ghost Blank Cell References	David P	Excel Worksheet Functions	1	February 4th 05 03:27 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 03:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us