Combining two formulas

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

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

I'm not entirely certain of what you are trying to achieve but I think this
is the formula you are after:

=IF(WEEKDAY(R6,2)<5,IF(Data!CY8<0,(Data!CY8*1.23)-ABS(Data!CY8)+Data!CY8,Data!CY8*1.13),Data!CY8*1.23)

Note, in your example you didn't have the correct number of ( ) so I have
put in those that I think are right. You may need to change this to get the
correct formula.

HTH

Ian

"edwardpestian" wrote:

>
> 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
>
>

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
>
>

=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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>