If Formula Help Please

[stephen.smith]

Hi Guys
I have a macro running in one workbook which has an output value of 1,2,3 or 4 depending on th selection made by the user. In another workbook I have the information being collected and have run into an issue. I am trying to run an if formula but it doesnt seem to work. This is the formula in question
=IFERROR(IF(D1346>1,"Alert",""),"")
The cell the information resides in is D1346, if the cell has 2,3 or 4 i would like the cell i am using this formula on to display alert. If the D1346 is empty or holds the value 1 I would like it to remain empty but this doesnt work. The cell reads Alert if D1346 is empty. What am I doing wrong?
Thanks for your help again
Stephen

 

[Jonmo1]

Try

=IFERROR(IF(OR(D1246={"",1}),"","Alert"),"")