+ Reply to Thread
Results 1 to 3 of 3

Need IF function for looking at several columns and choosing a value for different columns

  1. #1
    Registered User
    Join Date
    02-22-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    9

    Need IF function for looking at several columns and choosing a value for different columns

    Sample spreadsheet.xlsx
    I have attached a spreadsheet that I need some formulas for.

    In the J column, I would like it to look at which columns (D through G) have an X.
    If it is just D, then I want it to return the value from cell N2.
    If it is D plus just E, then I want it to return the value from cell O2.
    If it is D plus just F, then I want it to return the value from cell P2.
    If it is D plus E and F, then I want it to return the value from Q2.
    If it is G, then I want it to return the value of 0

    For column K, I would like it to look at the category in column C.
    If the category is H, then I want it to divide the value from column J by 4.
    All other categories would divide the value from column J by 2.

    At the bottom of the spreadsheet, I have listed the separate categories in column I and would like it to total the monthly deduction from column J.
    For example, J43 would just have the totals for those in category A (from column C).

    I would really appreciate some help on this.

    And just in case you are looking at Person 33, that person does not have to pay for insurance so there is no monthly deduction and the cells can just be left blank.

  2. #2
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Need IF function for looking at several columns and choosing a value for different col

    Does the attached help?
    Attached Files Attached Files
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  3. #3
    Registered User
    Join Date
    02-22-2013
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Need IF function for looking at several columns and choosing a value for different col

    Quote Originally Posted by Ace_XL View Post
    Does the attached help?
    I think so...I need to dissect the formula because I asked for the row 2 cells to be retrieved instead of the row 3 cells. Once I get that straight, I should be ok. Thanks!

+ 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