Home |
Search |
Today's Posts |
#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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
JulieD and Myrna, both your speedy solutions work.
Thank you. RobertR |
#5
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
Yes Julie, I did that.
Thanks. RobertR |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combine two formulas in one cell | Excel Discussion (Misc queries) | |||
How do I combine the 4 IF formulas into 1 formula | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
How can I combine IF, COLUMN, and LARGE formulas in a single cell? | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |