Help combine 2 formulas into 1
 

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( I5E5,E5,I5)

Thank you.
RobertR

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" wrote in message
...
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( I5E5,E5,I5)

Thank you.
RobertR

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
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( I5E5,E5,I5)

Thank you.
RobertR

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

RobertR

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

"Robert" wrote in message
...
JulieD and Myrna, both your speedy solutions work.
Thank you.

RobertR

Yes Julie, I did that.
Thanks.

RobertR