I've set up an IF statement to check a cell between two dates using AND but for some reason it's not giving the correct result when the date entered is before the date that I am checking it against. It returns a zero result.
Any ideas where I'm going wrong in the formula?
=IF(AND(K$43+0>$C45+0,K$43+0<$D45),+$H45*(DAYS360(K$43,L$43)),0)
Here's a screenshot:
https://dl.dropboxusercontent.com/u/23192837/Screen Shot 2015-05-18 at 22.14.57.png
Thanks
Paul
Any ideas where I'm going wrong in the formula?
=IF(AND(K$43+0>$C45+0,K$43+0<$D45),+$H45*(DAYS360(K$43,L$43)),0)
Here's a screenshot:
https://dl.dropboxusercontent.com/u/23192837/Screen Shot 2015-05-18 at 22.14.57.png
Thanks
Paul