Posted to microsoft.public.excel.worksheet.functions

Meebers[_2_] Meebers[_2_] is offline

external usenet poster

Posts: 36

divide by zero

If in cell c1 I have a formula =a1/b1 and either one or both are empty, how
do I check for that so as not to produce a divide by 0.

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
Divide By help?	kirstie adam	Excel Worksheet Functions	2	December 5th 06 04:23 PM
divide by zero	chiuinggum	Excel Worksheet Functions	1	April 8th 06 09:52 AM
divide by 0	sony654	Excel Worksheet Functions	4	April 24th 05 08:10 AM
Divide by Zero	rocky	Excel Worksheet Functions	3	April 22nd 05 12:50 PM
Divide one row over other row I dont wont to divide one number	Rick	Excel Discussion (Misc queries)	0	March 4th 05 07:13 PM

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

About Us

"It's about Microsoft Excel"