software

hey guy's
A1 = 500-400, but if A1 equals a negative then i need A1 to equal
0.
please help.

thanks,
jason--
jwfakouri
------------------------------------------------------------------------
jwfakouri's Profile: www.excelforum.com/member.php...oamp;userid=31435
View this thread: www.excelforum.com/showthread...hreadid=521982
Try this:

A1: =MAX(500-400,0)

Does that give you something to work with?

Regards,
Ron--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: www.excelforum.com/member.php...oamp;userid=21419
View this thread: www.excelforum.com/showthread...hreadid=521982There's no formula which would set A1 to 0 if it was negative. You could do this
with a macro, but I doubt you need to go to this much trouble. Your likely best
bets a

1. If there currently is a formula in A1, then change it to an IF statement, as
in:

=if(b1-c1lt;0,0,b1-c1)

2. If you have other formulas referring to A1, have them test for a negative
value first.

--
Regards,
Fredquot;jwfakouriquot; gt; wrote in
message ...
gt;
gt; hey guy's
gt; A1 = 500-400, but if A1 equals a negative then i need A1 to equal
gt; 0.
gt; please help.
gt;
gt; thanks,
gt; jason
gt;
gt;
gt; --
gt; jwfakouri
gt; ------------------------------------------------------------------------
gt; jwfakouri's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31435
gt; View this thread: www.excelforum.com/showthread...hreadid=521982
gt;
=MAX(500-400,0)
--
tjquot;jwfakouriquot; wrote:

gt;
gt; hey guy's
gt; A1 = 500-400, but if A1 equals a negative then i need A1 to equal
gt; 0.
gt; please help.
gt;
gt; thanks,
gt; jason
gt;
gt;
gt; --
gt; jwfakouri
gt; ------------------------------------------------------------------------
gt; jwfakouri's Profile: www.excelforum.com/member.php...oamp;userid=31435
gt; View this thread: www.excelforum.com/showthread...hreadid=521982
gt;
gt;