| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Nested if formula question
Can you help me out with this formula?
if(and((F20<($F$87*$K$4),(E20/$E$87)$M$4)),"down",,if(and((F20($F$87*$L$4),(E2 0/$E$87)$M$4)),"up","") I am putting together a spreadsheet that divides sales by certain categories (rows 4:86) with the total sales summed in row 87. Column F holds a year over year change, I am trying to have excel tell me the categories that are above or below our average by a certain percentage (K4 and L4) and have placed a certain number of orders (M4). Thanks so much for this help |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nested if formula question
=IF(AND(F20<$F$87*$K$4,E20/$E$87$M$4),"down",IF(AND(F20$F$87*$L$4,E20/$E$87$M$4),"up",""))
Not tested, I fixed the syntax only! Regards, Stefi phd4212 ezt *rta: Can you help me out with this formula? if(and((F20<($F$87*$K$4),(E20/$E$87)$M$4)),"down",,if(and((F20($F$87*$L$4),(E2 0/$E$87)$M$4)),"up","") I am putting together a spreadsheet that divides sales by certain categories (rows 4:86) with the total sales summed in row 87. Column F holds a year over year change, I am trying to have excel tell me the categories that are above or below our average by a certain percentage (K4 and L4) and have placed a certain number of orders (M4). Thanks so much for this help |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nested if formula question
Thanks a lot!
"Stefi" wrote: =IF(AND(F20<$F$87*$K$4,E20/$E$87$M$4),"down",IF(AND(F20$F$87*$L$4,E20/$E$87$M$4),"up","")) Not tested, I fixed the syntax only! Regards, Stefi phd4212 ezt *rta: Can you help me out with this formula? if(and((F20<($F$87*$K$4),(E20/$E$87)$M$4)),"down",,if(and((F20($F$87*$L$4),(E2 0/$E$87)$M$4)),"up","") I am putting together a spreadsheet that divides sales by certain categories (rows 4:86) with the total sales summed in row 87. Column F holds a year over year change, I am trying to have excel tell me the categories that are above or below our average by a certain percentage (K4 and L4) and have placed a certain number of orders (M4). Thanks so much for this help |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Nested if formula question
You are welcome! Thanks for the feedback!
Stefi phd4212 ezt *rta: Thanks a lot! "Stefi" wrote: =IF(AND(F20<$F$87*$K$4,E20/$E$87$M$4),"down",IF(AND(F20$F$87*$L$4,E20/$E$87$M$4),"up","")) Not tested, I fixed the syntax only! Regards, Stefi phd4212 ezt *rta: Can you help me out with this formula? if(and((F20<($F$87*$K$4),(E20/$E$87)$M$4)),"down",,if(and((F20($F$87*$L$4),(E2 0/$E$87)$M$4)),"up","") I am putting together a spreadsheet that divides sales by certain categories (rows 4:86) with the total sales summed in row 87. Column F holds a year over year change, I am trying to have excel tell me the categories that are above or below our average by a certain percentage (K4 and L4) and have placed a certain number of orders (M4). Thanks so much for this help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy Nested IF formula question, please help | Excel Worksheet Functions | |||
| Nested IF question | Excel Worksheet Functions | |||
| I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
| Excel nested IF formula question | Excel Discussion (Misc queries) | |||
| large formula question - Max nested functions | Excel Worksheet Functions | |||
Hybrid Mode
