Nested if formula question

[phd4212]

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),(E20/$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

 

[Stefi]

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

 

[phd4212]

Thanks a lot!

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

 

[Stefi]

You are welcome! Thanks for the feedback!
Stefi

„phd4212†ezt írta: