Results 1 to 3 of 3

If Statement HELP

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2011
    Location
    austin
    MS-Off Ver
    Excel 2010
    Posts
    9

    If Statement HELP

    Okay so i have a complicated If statement i cannot seem to get working

    =IF(ISNUMBER(SEARCH("neon",AE4)),(IF(AG4>248,"TRUE",(IF(ISNUMBER(SEARCH("LED",AE4)),(IF(AG4>198,"TRUE","")))))))

    What I am trying to do is look in Cell AE4. If it contains "neon" then i want to check the price in AG4 to see if the price is greater than X if it is i want it to be true. If not then I want it to look in AE4 again and see if LED is in the cell and so on.

    Someone please help me the first half of this works but it does not work properly when it gets to the LED part of the formula.
    Last edited by everythingneon; 06-28-2011 at 09:39 PM.

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