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,"TRU E","")))))))
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.
Hi Everythingneon, welcome to the forum.
Perhaps this modification will work correctly for you:
=IF(OR(AND(ISNUMBER(SEARCH("neon",AE4)),AG4>248),AND(ISNUMBER(SEARCH("LED",AE4)),AG4>198)),"TRUE","" )
Hope that helps!
Worked Wonderfully. I am going to try to use that logic on another one. Much more clean than mine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks