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

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

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

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