IF Statement

[kvandalia]

Is there any reason this statement should not work?

=IF(H3="034","AGR","")

[#2]

@kvandalia 

Hi there,

Your formula must work if 034 has been input to H34 Cell in text format. I mean if you enter '034 value into the cell, formula will work.

If you find this solution satisfactory and as your best solution, please mention it.

Thanks in advance.

[#3]

Hello @kvandalia,

As @Ilgar_Zarbaliyev mentioned, this formula will return "AGR" if cell H3 contains text exactly as "034". If you enter 034 into H3 as a number then the formula will return "".

[#4]

@kvandalia 

What do you mean exactly under not work ?

If it returns wrong result perhaps value in cell is not as your expect.

If it gives the message about incorrect formula, as variant you shall use semicolons instead of commas as delimiters.