+ Reply to Thread
Results 1 to 6 of 6

MultiConditional Formatting or MultiFormula?

  1. #1
    Registered User
    Join Date
    03-11-2013
    Location
    Dallas TX
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question MultiConditional Formatting or MultiFormula?

    I'm a newbie to the forum. I learned Excel by the OJT and "Stumble" methods. I am starting to wish I had used the forum sooner. I don't know the most efficient(easiest with least amount of formulas/columns) way to do the following:

    H has imputted data
    J has imputted data
    K needs to show either H or J data depending on which is less but only if H is greater than 0

    Example (I am trying make sure I can understand what I'm doing not implying you don't understand.)
    H8 has value $5000.00
    J8 has value $1000.00
    K8 would be J8 "$1000.00"
    H9 has value $0.00
    J9 has value $300.00
    K9 would be $0.00
    H10 has value $500.00
    J10 has value $750.00
    K10 would be $500.00

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,064

    Re: MultiConditional Formatting or MultiFormula?

    in K8
    =MIN(H8,J8)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    03-11-2013
    Location
    Dallas TX
    MS-Off Ver
    Excel 2010
    Posts
    4

    Thumbs up Re: MultiConditional Formatting or MultiFormula?

    Quote Originally Posted by Special-K View Post
    in K8
    =MIN(H8,J8)
    Thank you for responding so quickly! I can see how this formula would work. I kept trying to make "IF" work.

  4. #4
    Registered User
    Join Date
    03-11-2013
    Location
    Dallas TX
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Re: MultiConditional Formatting or MultiFormula?

    OK now for the complicated part of this same spreadsheet.


    Like before
    H has imputted data
    J has imputted data
    K needs to show either H or J data depending on which is less but only if H is greater than 0
    L now needs to show the value of H minus K unless H is 0.
    Examples:
    H14: 630
    J14: 210
    K14: =MIN(H8,J8)or in this case 210
    L14: 420

    H14: 0
    J14: 210
    K14: =MIN(H8,J8)or in this case 0
    L14: 0


  5. #5
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: MultiConditional Formatting or MultiFormula?

    And what should it show if the value in H is 0 ?

  6. #6
    Registered User
    Join Date
    03-11-2013
    Location
    Dallas TX
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: MultiConditional Formatting or MultiFormula?

    That value would be 0.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1