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.
Bookmarks