+ Reply to Thread
Results 1 to 4 of 4

Please help with IF functions :)

  1. #1
    Registered User
    Join Date
    04-19-2021
    Location
    Glasgow, Scotland
    MS-Off Ver
    360
    Posts
    2

    Please help with IF functions :)

    Dear excel friends, I would be forever indebted to whoever could help me with IF functions, if that is indeed the correct function. Basically, I have 4 columns of numbers, and I need to generate "positive" or "negative" values based on combinations of the 4 columns. For example, if D2 and F2 are both <=45 then H2 is positive. If E2 and F2 are both <=45 then I2 is positive. If D2 and G2 are both <=45 then J2 is positive, and if E2 and G2 are both <=45 then K2 is positive. Hope this makes sense. I can't seem to attach the spreadsheet for some reason.

    Kindest regards
    CS
    Last edited by Confused Scientist; 04-19-2021 at 10:27 AM.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Please help with IF functions :)

    Not clear of what you mean by "is positive" Do you mean that there is a formula in H2 and you want it to return a positive number if conditions are met or do you mean that H2 returns "positive"
    Assuming the second, then, for example,
    =IF(AND(D2<=45, F2<=45), "positive", "something else")

    To upload a spreadsheet, follow the directions in the yellow banner at the top of the page.
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2021 H: 365
    Posts
    940

    Re: Please help with IF functions :)

    Does the attached example cover what you need?

    Regards,

    Snook
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    04-19-2021
    Location
    Glasgow, Scotland
    MS-Off Ver
    360
    Posts
    2

    Re: Please help with IF functions :)

    Thank you so much ChemistB! You're a star

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 08-18-2017, 11:53 AM
  2. Replies: 9
    Last Post: 06-13-2017, 01:41 PM
  3. Replies: 6
    Last Post: 03-17-2015, 01:35 AM
  4. Replies: 1
    Last Post: 02-10-2012, 05:27 PM
  5. Replies: 0
    Last Post: 11-15-2007, 05:24 AM
  6. [SOLVED] efficiency: database functions vs. math functions vs. array formula
    By nickname in forum Excel General
    Replies: 2
    Last Post: 07-13-2006, 11:30 PM
  7. Replies: 0
    Last Post: 06-05-2006, 05:20 AM

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