I have a spreadsheet that contains certain formulas based on constants stored in another sheet. I have created this formula now which goes like this

=IF(C3=Staff_Profile!$C$5,IF(Staff_Profile!$C$2="Expat",2000," "))

The above formula work on two conditions :

1) the staff has joined in a particular month

AND

2) the staff profile is "Expat"

If both conditions are satisfied then the formula applies 2000 $ recruitment charges , else it is 0 (zero)

While it returns 2000 as true value where it is required, for rest of the cells it returns value "FALSE", which I dont want to see. I need to see 0 (ZERO). I am confused , as to how this can be achieved.

Appreciate your help.