search cell if X and Y values are the same; search if X > Y; and search if cell does NOT contain

[Mr2017]

Hi

I've three quick questions, please:

1) Is it possible to create a formula which which can search for two different numbers in a cell and IF they are the same, return a result? Eg if a cell had "3 for 3" I'd like to return the words "same numbers"

2) If a cell had two values but X was greater than Y eg 5 for 3, I'd like to return "X greater than Y"

3) if a cell does NOT contain specific words eg "for" and "buy" I'd like to return "Fixed Price."

I've used the search function to return values eb with the data below, if the word "Now" is in cell A1 and the word "Extra" is in cell A2, then putting this formula in cell B1 will return "Price Cut" and dragging it down to B2 will return "Added Value" so I guess I need a variation of this formula? =IF(ISNUMBER(SEARCH("Now",A1)),"Price Cut",IF(ISNUMBER(SEARCH("Extra",A1)),"Added Value",""))

Now	Price Cut
Extra	Added Value

<colgroup><col><col></colgroup><tbody>
</tbody>

 

[Mr2017]

I found a solution for question 3 above.

If the text "abc" is in cell A1 and this formula is in cell B1, then the formula will return a blank: =IF(ISERROR(SEARCH("abc",A1)),"Happy 4th of July","")