Posted to microsoft.public.excel.misc

external usenet poster

Posts: 112

display negative numbers as zero

can i display a negative number as a zero?

thus if my formula reads: if(a4a5, a2, a4-a2) but a4-a2 cannot equal a
negative number? lowest it can be is zero. this formula appears on multiple
workbooks, thus it cannot just be if(a4a5, a2,0).

thnaks.

--
Andrea

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 negative results	Rhonda	Excel Worksheet Functions	11	October 17th 06 07:24 PM
Find negative numbers	Kitty	Excel Discussion (Misc queries)	7	October 10th 06 07:33 PM
how to display numbers in thousands i.e display 10,000 as 10	excel2002	Excel Worksheet Functions	4	April 26th 06 07:53 PM
Compare Negative & Positive Numbers	chom	New Users to Excel	3	July 28th 05 08:26 AM
Negative Numbers	Glenda	Excel Discussion (Misc queries)	3	November 26th 04 02:06 PM

All times are GMT +1. The time now is 02:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us