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
|