Remember Me?

#1
 Robert Posts: n/a
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
#2
 JulieD Posts: n/a

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

#3
 Myrna Larson Posts: n/a

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

#4
 Robert Posts: n/a

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

RobertR

#5
 JulieD Posts: n/a

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

#6
 Robert Posts: n/a

Yes Julie, I did that.
Thanks.

RobertR

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post T.R. Excel Discussion (Misc queries) 1 March 10th 05 12:55 AM Robert Excel Worksheet Functions 5 February 7th 05 09:19 AM nathan Excel Worksheet Functions 0 January 21st 05 05:07 PM Liam Judd Excel Worksheet Functions 1 November 17th 04 08:52 AM Chad Excel Worksheet Functions 3 November 13th 04 06:22 PM

All times are GMT +1. The time now is 12:37 AM.