IF Function

[chris_h_465]

I have the following formula attached to the end of several other if functions defining the value of the cell.

IF((-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3)<0,0)

But the problem is that if the result of the cell value -BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3 isn't < 0 I want it to display what the cell value -BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3 is?

Can anybody help?

Cheers

Hi

Try this:
IF(-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3<0,0,-BY3-CA3-CC3-CD3-CE3-CF3-CG3-CH3-CI3-CJ3)

Andy

"chris_h_465" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>

[Dana DeLouis]

> 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+Z>0

=MIN(SUM(BY3,CA3,CC3:CJ3),0)

HTH :>)
--
Dana DeLouis
Win XP & Office 2003


"chris_h_465" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>