+ Reply to Thread
Results 1 to 4 of 4

Simple multiple logic test help

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    44

    Simple multiple logic test help

    i have extremely basic skills when it comes to excel

    i have 2 cells

    H4 , H5

    i want H5 to have a figure depending on what H4 is

    this is what i will put in H5

    e.g

    =IF(H4=0,0) OR -- so if H4 is 0 put 0 in H5
    =IF(H4=1,18) OR -- if H4 is 1 put 18 in H5
    =IF(H4=2,23) OR -- If H4 is 2 put 23 in H5
    =IF(H4=3,30) -- If H4 is 3 put 30 in H5

    These formulas work individually, however i need them all into 1 formula and no matter what i try i just get errors

    can anyone help

    Many Thanks
    Last edited by rexy69; 09-06-2014 at 11:07 AM.

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Simple multiple logic test help

    Try this formula

    =LOOKUP(H4,{0,0;1,18;2,23;3,30})
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    44

    Re: Simple multiple logic test help

    works perfectly thanks a lot

  4. #4
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Simple multiple logic test help

    You're welcome and thank you for the feedback!

    Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools -> Mark thread as Solved).

+ 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. [SOLVED] Multiple logic test question
    By supernovartis in forum Excel General
    Replies: 4
    Last Post: 04-04-2014, 10:10 AM
  2. [SOLVED] logic test AND OR
    By censura in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2013, 05:48 AM
  3. Multiple logic test formulae
    By Jaime1234 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-11-2013, 12:27 PM
  4. [SOLVED] Need help on Logic test!!!
    By jbf frylock in forum Excel General
    Replies: 5
    Last Post: 01-09-2006, 05:45 PM
  5. logic test
    By toolman in forum Excel General
    Replies: 2
    Last Post: 10-08-2005, 09:05 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