Bodybuilding.com Information Motivation Supplementation
in:

    The World’s #1 Bodybuilding And Fitness Forum - Save Up To 50% Off Retail Prices In Our Bodybuilding.com Store!

Reply
Results 1 to 12 of 12
  1. #1
    im here for the bukkake garbazio's Avatar
    Join Date: Jul 2007
    Location: New York, United States
    Age: 22
    Stats: 6'3", 220 lbs
    Posts: 6,714
    BodyPoints: 1252
    Rep Power: 1161
    garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000)
    Visit garbazio's BodySpace
    garbazio is offline

    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"))
    bitches love my hair
    Reply With Quote

  2. #2
    im here for the bukkake garbazio's Avatar
    Join Date: Jul 2007
    Location: New York, United States
    Age: 22
    Stats: 6'3", 220 lbs
    Posts: 6,714
    BodyPoints: 1252
    Rep Power: 1161
    garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000)
    Visit garbazio's BodySpace
    garbazio is offline
    halp
    bitches love my hair
    Reply With Quote

  3. #3
    im here for the bukkake garbazio's Avatar
    Join Date: Jul 2007
    Location: New York, United States
    Age: 22
    Stats: 6'3", 220 lbs
    Posts: 6,714
    BodyPoints: 1252
    Rep Power: 1161
    garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000)
    Visit garbazio's BodySpace
    garbazio is offline
    bomp
    bitches love my hair
    Reply With Quote

  4. #4
    that's not my name roger79's Avatar
    Join Date: May 2009
    Location: Montreal, Canada
    Age: 30
    Stats: 5'5", 143 lbs
    Posts: 1,638
    Rep Power: 2894
    roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000)
    Visit roger79's BodySpace
    roger79 is offline
    What's the purpose of F19:F20?
    ★ Go Habs ★

    ♡ poutine crew ♡


    Indochino $50 off: REFERRAL5045G6WU3
    Reply With Quote

  5. #5
    Banned Tomohawk92's Avatar
    Join Date: Sep 2009
    Stats: 5'9", 153 lbs
    Posts: 7,212
    Rep Power: 0
    Tomohawk92 is the lowest scum of the boards. (Worst Rank) Tomohawk92 is the lowest scum of the boards. (Worst Rank) Tomohawk92 is the lowest scum of the boards. (Worst Rank) Tomohawk92 is the lowest scum of the boards. (Worst Rank) Tomohawk92 is the lowest scum of the boards. (Worst Rank) Tomohawk92 is the lowest scum of the boards. (Worst Rank) Tomohawk92 is the lowest scum of the boards. (Worst Rank) Tomohawk92 is the lowest scum of the boards. (Worst Rank) Tomohawk92 is the lowest scum of the boards. (Worst Rank) Tomohawk92 is the lowest scum of the boards. (Worst Rank) Tomohawk92 is the lowest scum of the boards. (Worst Rank)
    Visit Tomohawk92's BodySpace
    Tomohawk92 is offline
    lol accounting
    Reply With Quote

  6. #6
    im here for the bukkake garbazio's Avatar
    Join Date: Jul 2007
    Location: New York, United States
    Age: 22
    Stats: 6'3", 220 lbs
    Posts: 6,714
    BodyPoints: 1252
    Rep Power: 1161
    garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000)
    Visit garbazio's BodySpace
    garbazio is offline
    Originally Posted by roger79 View Post
    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 View Post
    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
    bitches love my hair
    Reply With Quote

  7. #7
    im here for the bukkake garbazio's Avatar
    Join Date: Jul 2007
    Location: New York, United States
    Age: 22
    Stats: 6'3", 220 lbs
    Posts: 6,714
    BodyPoints: 1252
    Rep Power: 1161
    garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000)
    Visit garbazio's BodySpace
    garbazio is offline
    bomp
    bitches love my hair
    Reply With Quote

  8. #8
    that's not my name roger79's Avatar
    Join Date: May 2009
    Location: Montreal, Canada
    Age: 30
    Stats: 5'5", 143 lbs
    Posts: 1,638
    Rep Power: 2894
    roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000) roger79 has reached the pinnacle! Best possible rank! (+1000000)
    Visit roger79's BodySpace
    roger79 is offline
    {=MIN(IF(B3:G14>F20,B3:G14))}

    enter as array formula (ctrl+shift+enter)

    Cell F20 must contain only "7000" and not ">7000"
    ★ Go Habs ★

    ♡ poutine crew ♡


    Indochino $50 off: REFERRAL5045G6WU3
    Reply With Quote

  9. #9
    im here for the bukkake garbazio's Avatar
    Join Date: Jul 2007
    Location: New York, United States
    Age: 22
    Stats: 6'3", 220 lbs
    Posts: 6,714
    BodyPoints: 1252
    Rep Power: 1161
    garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000)
    Visit garbazio's BodySpace
    garbazio is offline
    says we need to use =Dmin
    bitches love my hair
    Reply With Quote

  10. #10
    im here for the bukkake garbazio's Avatar
    Join Date: Jul 2007
    Location: New York, United States
    Age: 22
    Stats: 6'3", 220 lbs
    Posts: 6,714
    BodyPoints: 1252
    Rep Power: 1161
    garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000) garbazio has reached the pinnacle! Best possible rank! (+1000000)
    Visit garbazio's BodySpace
    garbazio is offline
    bumping, says we need to use =Dmin
    bitches love my hair
    Reply With Quote

  11. #11
    ¯\_(ツ)_/¯ P51's Avatar
    Join Date: May 2007
    Location: United States
    Stats: 5'11", 175 lbs
    Posts: 23,853
    BodyPoints: 5556
    Rep Power: 104003
    P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000)
    Visit P51's BodySpace
    P51 is offline
    You owe me $1 for your other excel thread....
    | ♫Audiophile♫ | To ∞ & → | The Ohio State University Alumni |

    Headphone question?
    http://forum.bodybuilding.com/showthread.php?t=139399693

    Crohn's Awareness Week. Aware Yourself!
    http://forum.bodybuilding.com/showthread.php?t=150077053
    Reply With Quote

  12. #12
    ¯\_(ツ)_/¯ P51's Avatar
    Join Date: May 2007
    Location: United States
    Stats: 5'11", 175 lbs
    Posts: 23,853
    BodyPoints: 5556
    Rep Power: 104003
    P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000) P51 has reached the pinnacle! Best possible rank! (+1000000)
    Visit P51's BodySpace
    P51 is offline
    =DMIN(B3:G14,"Sales Price",F19:F20)
    | ♫Audiophile♫ | To ∞ & → | The Ohio State University Alumni |

    Headphone question?
    http://forum.bodybuilding.com/showthread.php?t=139399693

    Crohn's Awareness Week. Aware Yourself!
    http://forum.bodybuilding.com/showthread.php?t=150077053
    Reply With Quote

Reply

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Home Store Products Careers Help Contact Us Terms of Use Checkout