I've looked again and I now see what you are doing. Does this work? It
looks OK to me.
Ian
"edwardpestian" wrote:
Here's what I came up with:
=IF(WEEKDAY(R6,2)<5,(IF(Data!CZ8<0,(ABS(Data!CZ8)* Data!DK6)-(ABS(Data!CZ8))+(Data!CZ8),Data!CZ8*Data!DK6)),(IF (Data!CZ8<0,(ABS(Data!CZ8)*Data!DK7)-(ABS(Data!CZ8))+(Data!CZ8),Data!CZ8*Data!DK7)))
EP
--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=548244