Help combine 2 formulas into 1

[Robert]

I am dumbfounded. Just could not do it to combine the following
2 formulas in cols I and J into 1 formula in col J.
Cell I5
=IF(F5<0,(INT(F5/D5)*-D5),0)
Cell J5
=if( I5>E5,E5,I5)

Thank you.
RobertR

[JulieD]

Hi Robert

try
=IF(IF(F5<0,(INT(F5/D5)*-D5),0)>E5,E5,IF(F5<0,(INT(F5/D5)*-D5),0))

Cheers
JulieD

"Robert" <[email protected]> wrote in message
news:[email protected]...
>I am dumbfounded. Just could not do it to combine the following
> 2 formulas in cols I and J into 1 formula in col J.
> Cell I5
> =IF(F5<0,(INT(F5/D5)*-D5),0)
> Cell J5
> =if( I5>E5,E5,I5)
>
> Thank you.
> RobertR

[Myrna Larson]

With nothing in I5 and this formula in J5:

=MIN(E5,IF(F5<0,(INT(F5/D5)*-D5),0))


On Thu, 31 Mar 2005 18:25:05 -0800, Robert <[email protected]>
wrote:

>I am dumbfounded. Just could not do it to combine the following
>2 formulas in cols I and J into 1 formula in col J.
>Cell I5
>=IF(F5<0,(INT(F5/D5)*-D5),0)
>Cell J5
>=if( I5>E5,E5,I5)
>
>Thank you.
>RobertR

[Robert]

JulieD and Myrna, both your speedy solutions work.
Thank you.

RobertR

[JulieD]

you're welcome and thanks for the feedback (hope you went with Myrna's it's
an awful lot less typing than mine!)

"Robert" <[email protected]> wrote in message
news:[email protected]...
> JulieD and Myrna, both your speedy solutions work.
> Thank you.
>
> RobertR
>
>

[Robert]

Yes Julie, I did that.
Thanks.

RobertR