Hello! I am using this formula:
=IF(OR($U2>EOMONTH(AF$1,0),$V2<AF$1),??,$AE2*(MIN(EOMONTH(AF$1,0),$V2)-MAX(AF$1,$U2)+1)/IF(MOD(YEAR($AF$1),4)=0,366,365))
I need to make this formula multiply by whatever is in cell C3 if the value returned is greater than 0. I tried the product function but I am having trouble with placing it into the formula. I keep getting the error #Value
Bookmarks