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