I am converting a sheet to excel and have this combination of functions in a cell that I am trying to translate to excel but I am having trouble understanding how the datevalue and a few other functions work in this:
+BT10*((BZ10*(@MONTH($DATE2)=@MONTH(BW10))*(@YEAR($DATE2)=@YEAR(BW10)))+(@IF(@ISERR(@DATEVALUE(ERR))=1,@DAY($DATE2),@DATEVALUE($DATE2)-@DATEVALUE(ERR))*((@MONTH($DATE2)<>@MONTH(BW10))#OR#(@YEAR($DATE2)<>@YEAR(BW10)))))*10*(@DATEVALUE(BW10)<=@DATEVALUE($DATE2))
Any suggestions??
Would be very appreciated!!!
NAVYA.
+BT10*((BZ10*(@MONTH($DATE2)=@MONTH(BW10))*(@YEAR($DATE2)=@YEAR(BW10)))+(@IF(@ISERR(@DATEVALUE(ERR))=1,@DAY($DATE2),@DATEVALUE($DATE2)-@DATEVALUE(ERR))*((@MONTH($DATE2)<>@MONTH(BW10))#OR#(@YEAR($DATE2)<>@YEAR(BW10)))))*10*(@DATEVALUE(BW10)<=@DATEVALUE($DATE2))
Any suggestions??
Would be very appreciated!!!
NAVYA.