Need Help? Customer Support 1-866-236-8417

# Thread: Excel halp, pls, will rape

1. ## Excel halp, pls, will rape

In cell G19, enter a function that will find the lowest Sales Price over \$7,000 for the range B3:G14 using the criteria in cells F19:F20.

so yea, i tried doing it through =min and =mina but i screwed up somewhere both times

currently have this

=MINA(IF(E\$3\$:E\$14\$>7000,"=min"))

2. halp

3. bomp

4. What's the purpose of F19:F20?

5. lol accounting

6. Originally Posted by roger79
What's the purpose of F19:F20?
its just two cells, top one says sales price, bottom has >7000 on it

Originally Posted by Buegie
easy way would be to replicate the sales price box and use a formula for each cell to only show something if it is above your \$7,000 threshold...such as:

If(A1>\$B\$1,A1,"")

Then you can do a regular min function for all of those cells

EDIT: then obviously you hide the new rows/columns
i think professor wanted me to use min or incorporation of min

7. bomp

8. {=MIN(IF(B3:G14>F20,B3:G14))}

enter as array formula (ctrl+shift+enter)

Cell F20 must contain only "7000" and not ">7000"

9. says we need to use =Dmin

10. bumping, says we need to use =Dmin