=IF(WEEKDAY(R6,2)<5,C8+ABS(C8*0.13),C8+ABS(C8*0.23 ))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"edwardpestian"
wrote in message
news:edwardpestian.28vaky_1149407102.704@excelforu m-nospam.com...

I have two formulas. The first one determines what day of the week it
is and multiplies that cell by a percentage.

=IF(WEEKDAY(R6,2)<5,Data!CY8*1.13,Data!CY8*1.23).

This formula works fine if it is a positive number. It basically
increases the number by the respective percentage.

However, if the number is negative, I get the negative number increased
further into the negative. What I want it to do is decrease.

For example. 150,000 would return 184,500 and -150,000 would
return115,500. I have created a formula that accomplishes what I need,
but I do not know how to implement with the above formula.

=IF(Data!CY8<0,(Data!CY8)*1.23)-(ABS(Data!CY8))+(Data!CY8),Data!CY8*1.23)

Thanks in advance.

EP


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=548244