Results 1 to 9 of 9

Math Help - excel

  1. #1
    Newbie
    Joined
    Apr 2008
    Posts
    5

    excel

    PROBLEM 6
    Step 2
    In Cells D7 - D13, enter a formula using the IF logical function to place the amount in Cells B7 - B13 in cells D7 - D13 if the amount in Cells B7 - B13 is Over $80,000. (If the amount in cells B7 - B13 is greater than $80,000, then the amount should be placed in cells D7 - D13)
    Last edited by camincho; April 21st 2008 at 08:29 AM. Reason: Entered wrong info
    Follow Math Help Forum on Facebook and Google+

  2. #2
    GAMMA Mathematics
    colby2152's Avatar
    Joined
    Nov 2007
    From
    Alexandria, VA
    Posts
    1,172
    Awards
    1
    Quote Originally Posted by camincho View Post
    PROBLEM 6
    Step 2
    In Cells D7 - D13, enter a formula using the IF logical function to place the amount in Cells B7 - B13 in cells D7 - D13 if the amount in Cells B7 - B13 is Over $80,000. (If the amount in cells B7 - B13 is greater than $80,000, then the amount should be placed in cells D7 - D13)
    Is this a Microsoft Excel question?

    If so, then do the following:

    Goto cell D7 and type: =IF(b7>80000,b7,*)

    *I don't know what your if false condition is... let's assume you want a minimum of 80,000 placed there, then:

    Goto cell D7 and type: =IF(b7>80000,b7,80000)

    You could easily do the same with the maximum function

    Goto cell D7 and type: =Max(80000,b7)

    Did that help you?
    Follow Math Help Forum on Facebook and Google+

  3. #3
    Newbie
    Joined
    Apr 2008
    Posts
    5

    Smile Thank you!

    Yes, it is Excel, email.xls
    I am a newbie, please email me to camincho@gmail.com if you do not get my attachment, so that I can send you exactly what I need, in the meantime, I will try to follow your directions, thank you, Camincho
    Quote Originally Posted by colby2152 View Post
    Is this a Microsoft Excel question?

    If so, then do the following:

    Goto cell D7 and type: =IF(b7>80000,b7,*)

    *I don't know what your if false condition is... let's assume you want a minimum of 80,000 placed there, then:

    Goto cell D7 and type: =IF(b7>80000,b7,80000)

    You could easily do the same with the maximum function

    Goto cell D7 and type: =Max(80000,b7)

    Did that help you?
    Follow Math Help Forum on Facebook and Google+

  4. #4
    GAMMA Mathematics
    colby2152's Avatar
    Joined
    Nov 2007
    From
    Alexandria, VA
    Posts
    1,172
    Awards
    1
    I am not in a position right now to download attachments, but this link should be a great free (and paid if you choose to buy one of his great books) resource on Excel: Mr. Excel
    Follow Math Help Forum on Facebook and Google+

  5. #5
    Newbie
    Joined
    Apr 2008
    Posts
    5

    Smile Thanks again!, I am getting half way there

    Thank you, I have half of my problem solved, and now I just need to find out what to do with the amounts that are less than 80000, right now they are showing with FALSE in the cell, anyway, thanks for your help, sincerely, Camincho
    Follow Math Help Forum on Facebook and Google+

  6. #6
    GAMMA Mathematics
    colby2152's Avatar
    Joined
    Nov 2007
    From
    Alexandria, VA
    Posts
    1,172
    Awards
    1
    Quote Originally Posted by camincho View Post
    Thank you, I have half of my problem solved, and now I just need to find out what to do with the amounts that are less than 80000, right now they are showing with FALSE in the cell, anyway, thanks for your help, sincerely, Camincho
    That depends on what you are trying to do in your problem? What is the if else condition?
    Follow Math Help Forum on Facebook and Google+

  7. #7
    Newbie
    Joined
    Apr 2008
    Posts
    5

    Here are the details

    Quota Over 8000
    45000 (leave cell blank if not over 80000)
    75000 (leave cell blank if not over 80000)
    85000 85000 (fill in amount if over 80000
    85000 85000 (fill in amount if over 80000)
    55000 (Leave cell blank if not over 80000)
    93000 93000 (fill in amount if over 80000)
    Follow Math Help Forum on Facebook and Google+

  8. #8
    GAMMA Mathematics
    colby2152's Avatar
    Joined
    Nov 2007
    From
    Alexandria, VA
    Posts
    1,172
    Awards
    1
    Quote Originally Posted by camincho View Post
    Quota Over 8000
    45000 (leave cell blank if not over 80000)
    75000 (leave cell blank if not over 80000)
    85000 85000 (fill in amount if over 80000
    85000 85000 (fill in amount if over 80000)
    55000 (Leave cell blank if not over 80000)
    93000 93000 (fill in amount if over 80000)
    Leave blank, so you would simply write O or "" as your FALSE condition.
    Follow Math Help Forum on Facebook and Google+

  9. #9
    Newbie
    Joined
    Apr 2008
    Posts
    5

    Smile Thank you!

    Thank you so much for your help! I am so sorry, I am just letting you know how thankful I am for your help, TTUL
    Follow Math Help Forum on Facebook and Google+

Similar Math Help Forum Discussions

  1. help in excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: May 26th 2011, 06:29 AM
  2. From Matlab to Excel
    Posted in the Math Software Forum
    Replies: 3
    Last Post: February 3rd 2010, 03:20 AM
  3. Calculus and Excel
    Posted in the Calculus Forum
    Replies: 0
    Last Post: December 6th 2009, 04:09 PM
  4. excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: January 21st 2008, 06:24 AM
  5. Excel
    Posted in the Math Software Forum
    Replies: 1
    Last Post: August 13th 2007, 06:26 PM

Search Tags


/mathhelpforum @mathhelpforum