IF((-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3)<0,0)
Hi. Note that with something like -X-Y-Z < 0
If you multiply both sides by -1, then you have
X+Y+Z0
=MIN(SUM(BY3,CA3,CC3:CJ3),0)
HTH :)
--
Dana DeLouis
Win XP & Office 2003
"chris_h_465"
wrote in message
...
I have the following formula attached to the end of several other if
functions defining the value of a cell.
IF((-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3)<0,0)
But the problem is that if the result of
-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3 isn't < 0 I want it to display
what -BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3 is?
Can anybody help?
Cheers
--
chris_h_465
------------------------------------------------------------------------
chris_h_465's Profile:
http://www.excelforum.com/member.php...o&userid=28233
View this thread: http://www.excelforum.com/showthread...hreadid=490698