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: 29
    Stats: 5'5", 143 lbs
    Posts: 1,626
    Rep Power: 2840
    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?
    ★ Habs ☆ Als ☆ Bills ☆ Impact FC ☆ Carabins ★



    ♡ poutine crew ♡
    Reply With Quote

  5. #5
    Stalling @ 3,300 calories Tomohawk92's Avatar
    Join Date: Sep 2009
    Stats: 5'9", 153 lbs
    Posts: 7,125
    Rep Power: 1716
    Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000) Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000) Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000) Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000) Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000) Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000) Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000) Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000) Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000) Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000) Tomohawk92 has reached the pinnacle! Best possible rank! (+1000000)
    Visit Tomohawk92's BodySpace
    Tomohawk92 is offline
    lol accounting
    Prevent/Treat Cancer with NUTRITION: http://forum.bodybuilding.com/showthread.php?t=154102201

    ★ Senior Aerospace/Mechanical Engineer ★
    ★ Chalk, Double Overhand ★

    Deadlift
    315 [x]
    345 [x] Sep. 17
    365 [ ] Oct. 30


    Don't try to argue if you forgot to bring your ****ing sources
    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: 29
    Stats: 5'5", 143 lbs
    Posts: 1,626
    Rep Power: 2840
    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"
    ★ Habs ☆ Als ☆ Bills ☆ Impact FC ☆ Carabins ★



    ♡ poutine crew ♡
    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,510
    BodyPoints: 5556
    Rep Power: 100524
    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,510
    BodyPoints: 5556
    Rep Power: 100524
    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