Results 1 to 8 of 8

IF formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2010
    Location
    Toronto, Ontario, Canada
    MS-Off Ver
    Excel 2010
    Posts
    47

    IF formula

    I am trying to create an IF formula which will be dependand on a number of variables. I have attached a sample of what I am doing. In Q3, I want it to return based on a number of potential conditions:

    if N5 if greater than 0 and A5 if less than 32, ..... the Lookup shown
    If N5 is greater than 0 and A5 is greater than 31, ..... the Lookup shown
    (the above is working - I want to add the blwo conditions as well)

    if L5 is greater than A5 and N5 if greater than 0 and A5 if less than 32, then same above look up however, instead of looking up

    "O3/(LOOKUP(A3,'T&O Pay Scale - 322 - Admin'!$A$3:$A$23,'T&O Pay Scale - 322 - Admin'!$C$3:$C$23)),IF(AND(M3>0,A3>31),O3/(LOOKUP(A3,'T&O Pay Scale - 350'!$A$2:$A$22,'T&O Pay Scale - 350'!$C$2:$C$22)"

    I want it to look up

    "O3/(LOOKUP(L3,'T&O Pay Scale - 322 - Admin'!$A$3:$A$23,'T&O Pay Scale - 322 - Admin'!$C$3:$C$23)),IF(AND(M3>0,A3>31),O3/(LOOKUP(A3,'T&O Pay Scale - 350'!$A$2:$A$22,'T&O Pay Scale - 350'!$C$2:$C$22)"

    Thank you for your help
    Attached Files Attached Files
    Last edited by stait; 10-04-2011 at 10:11 AM.

Thread Information

Users Browsing this Thread

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

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