![]() |
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