Posted to microsoft.public.excel.misc

[email protected] Brianburen@valornet.com is offline

external usenet poster

Posts: 1

if the # is a negative #, then show 0

I cant seem to figure out how to make a formula that when it performs its
calculation and the answer is a negative #, i want it to just show "0".
Is it a IF command?

thanks

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
add No's to show as hrs and mins (i.e 7.24+2.58 to show as 10.22)	Abrahams	Excel Discussion (Misc queries)	1	March 31st 06 01:48 PM
how do i show negative time in hours minutes	john tyler	Excel Worksheet Functions	0	March 6th 06 08:47 PM
Do not show negative numbers	roy.okinawa	Excel Discussion (Misc queries)	2	December 8th 05 12:55 AM
Instead of a negative number, I'd like to show zero...	Dr. Darrell	Excel Worksheet Functions	6	December 7th 05 08:21 PM
Have negative numbers show as zero	Domenic	Excel Worksheet Functions	0	November 9th 04 04:18 PM

All times are GMT +1. The time now is 10:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us