Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Robert
 
Posts: n/a
Default 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   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
Myrna Larson
 
Posts: n/a
Default

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   Report Post  
Robert
 
Posts: n/a
Default

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

RobertR


  #5   Report Post  
JulieD
 
Posts: n/a
Default

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   Report Post  
Robert
 
Posts: n/a
Default

Yes Julie, I did that.
Thanks.

RobertR

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine two formulas in one cell T.R. Excel Discussion (Misc queries) 1 March 10th 05 12:55 AM
How do I combine the 4 IF formulas into 1 formula Robert Excel Worksheet Functions 5 February 7th 05 09:19 AM
Problem with named formula's nathan Excel Worksheet Functions 0 January 21st 05 05:07 PM
How can I combine IF, COLUMN, and LARGE formulas in a single cell? Liam Judd Excel Worksheet Functions 1 November 17th 04 08:52 AM
calculating formulas for all workbooks in a folder Chad Excel Worksheet Functions 3 November 13th 04 06:22 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"