Posted to microsoft.public.excel.misc

Dena

external usenet poster

Posts: 12

Returning a zero

I have a worksheet with 2 sheets. The first sheet has all formulas and
depends on the second sheet. I need a formula in sheet 1 that subtracts cell
a1 from cell b1 but if cell a1 is zero I want the formula to return a zero.
Is this possible?

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
UDF from Add-In returning #NAME	ryan	Excel Worksheet Functions	0	March 5th 08 08:35 PM
Returning #N/A	Rao Ratan Singh	Excel Discussion (Misc queries)	5	January 25th 07 05:23 AM
Returning a 0 Value	Steved	Excel Worksheet Functions	3	July 29th 05 02:44 AM
Need some help returning a value	rcarrollct	Excel Worksheet Functions	2	July 6th 05 11:36 PM
Returning more than one value	DunderMifflin	Excel Discussion (Misc queries)	4	May 31st 05 04:40 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us