hey guy's
A1 = 500-400, but if A1 equals a negative then i need A1 to equal 0.
please help.
thanks,
jason
hey guy's
A1 = 500-400, but if A1 equals a negative then i need A1 to equal 0.
please help.
thanks,
jason
Try this:
A1: =MAX(500-400,0)
Does that give you something to work with?
Regards,
Ron
There'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 are:
1. If there currently is a formula in A1, then change it to an IF statement, as
in:
=if(b1-c1<0,0,b1-c1)
2. If you have other formulas referring to A1, have them test for a negative
value first.
--
Regards,
Fred
"jwfakouri" <[email protected]> wrote in
message news:[email protected]...
>
> 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:
> http://www.excelforum.com/member.php...o&userid=31435
> View this thread: http://www.excelforum.com/showthread...hreadid=521982
>
=MAX(500-400,0)
--
tj
"jwfakouri" wrote:
>
> 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: http://www.excelforum.com/member.php...o&userid=31435
> View this thread: http://www.excelforum.com/showthread...hreadid=521982
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks