Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 -- edwardpestian ------------------------------------------------------------------------ edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809 View this thread: http://www.excelforum.com/showthread...hreadid=548244 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining two formulas
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.2 3) 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining two formulas
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining two formulas
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
How prevent formulas to get external references/path to current workbook? | Excel Worksheet Functions | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
combining countif formulas | Excel Worksheet Functions |