+ Reply to Thread
Results 1 to 3 of 3

IF function HELP

  1. #1
    Registered User
    Join Date
    05-21-2012
    Location
    Toronto
    MS-Off Ver
    Excel 2003 & 2010
    Posts
    14

    IF function HELP

    I'm looking to selectly check my data using the if function

    I want to check all of column N to match "FRM" then only the once that matches "FRM check column G if it is less than 5 years (60 mths) and greater than3 years (36 mth) then only those cells that boatches both arguments check if column C is great that X if yes then output "Yes" if no then output "no"

    But I don't think this is working... anyone know why? should I use an array formula?
    =IF(Conventional!N5:N509="FRM",IF(Conventional!G5:G509<=36, IF(Conventional!G5:G509<=60, IF(Conventional!C5:C509>=(O30+1.15),"Yes","No"),"No"),"No")


    Thanks,

  2. #2
    Forum Contributor darknation144's Avatar
    Join Date
    01-24-2012
    Location
    London
    MS-Off Ver
    Microsoft Excel 365 MSO
    Posts
    555

    Re: IF function HELP

    So basically you are trying to do to much in one cell. =IF(Conventional!N5="FRM",IF(Conventional!G5<=36, IF(Conventional!G5<=60, IF(Conventional!C5>=(O30+1.15),"Yes","No"),"No"),"No") put that in P5 or which ever column you want and then copy it down.

    You don't need an array formula as each row will be evaluated seperately.
    If someone helped give them rep using the star button.

    If you have received a satisfactory solution please mark the thread solved. If not Fotis will come for you at night :P

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

    Re: IF function HELP

    Perhaps
    Please Login or Register  to view this content.

+ 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