Probably too late for this, but....
Excel does not use the ; it uses a comma to seperate the parts of the function.
The correct format for what you want to do is:
this will not make the false value appear if the criteria is not met.
The $ function is used to make cells absolute. So for example, you have a cell B1 with value =A1
if you copy this field down, each row underneath will change to the relative value - ie B2 will change to =A2, B3 will change to = A3, etc
If you put =A$1, when dragging the column down, the value will stay the same. So if cell B1 has value =A$1 and you drag this down for other cells, then the value will stay the same, ie =A$1 for B2, B3, B4 etc