Thread: Combining two formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwardpestian
 
Posts: n/a
Default Combining two formulas

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

Reply With QuoteReply With Quote