ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Consolidating a formula (https://www.excelbanter.com/excel-worksheet-functions/170189-consolidating-formula.html)

juliejg1

Consolidating a formula
 
I have the following formula that I would like to shorten if possible. This
is as compact as I can get it....any suggestions?


=IF(J$4$H5+MIN($D5,$E5),IF($E5=$D5,MIN($E5-$D5,DAYS360($H5+MIN($D5,$E5),J$4,FALSE))/30*($C5/12)-MIN($E5-$D5,MAX(DAYS360($H5+$I5*30+MIN($E5,$D5),J$4,FALSE) ,0))/30*($C5/12),MIN($D5-$E5,DAYS360($H5+MIN($D5,$E5),J$4,FALSE))/30*(-$C5/12)+MIN($D5-$E5,MAX(DAYS360($H5+$I5+MIN($D5,$E5)*30,J$4,FALSE) ,0))/30*($C5/12)),0)


All times are GMT +1. The time now is 09:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com