I have this long formula in Excel that I want to replicate in R Studio, because Excel takes a lot of time to calculate it on a large data set.
=IF(AND($DE4<BA$1,$DF4>=BA$1,$DF4<=BA$2),($DF4-BA$1+1)/($DF4-$DE4+1),IF(AND($DE4<BA$1,$DF4>BA$2),(BA$2-BA$1+1)/($DF4-$DE4+1),IF(AND($DE4>=BA$1,$DE4<=BA$2,$DF4<=BA$2,$DF4>=BA$1),1,IF(AND($DE4>=BA$1,$DE4<=BA$2,$DF4>BA$2),(BA$2-$DE4+1)/($DF4-$DE4+1),0))))*$DH4
BA1 = 1 Jan 2016 (Its a date)
BA2 = 31 Mar 2016 (Its a date)
DE4 = 12 Apr 2016 (Its a date
DF4 = 10 June 2017 (Its a date)
DH4 = 1795 (Its an integer)
Have found that writing longer ifelse statements is very difficult in R Studio, especially if dates are involved. Is there an easy way of doing that?