Removal of "False" message

[wallywalter]

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.

[Sam Capricci]

Have you tried adding IFERROR to it?

[benishiryo]

hi wallywater. maybe like this?
=IF(AND(C3=Staff_Profile!$C$5,Staff_Profile!$C$2="Expat"),2000,0)

not sure how the blank comes into play, since you didn't mention it.

[wallywalter]

Have you tried adding IFERROR to it?

I didnt try that; just thinking, does'nt it apply to remove those #N/A error messages ?

[wallywalter]

hi wallywater. maybe like this?
=IF(AND(C3=Staff_Profile!$C$5,Staff_Profile!$C$2="Expat"),2000,0)

not sure how the blank comes into play, since you didn't mention it.

Bingo ! That worked... Thanks a tonne

[Sam Capricci]

Unlike other posters on this forum I have more difficulty visualizing formulas if I can't put them in context so I would need to see a sample of the data to figure out how to get you different results.
Have you tried Benishiryo's reply yet? Posting a sample will likely help, if not by me certainly by others.

EDIT: sorry, your reply was added while i was typing.

[wallywalter]

Unlike other posters on this forum I have more difficulty visualizing formulas if I can't put them in context so I would need to see a sample of the data to figure out how to get you different results.
Have you tried Benishiryo's reply yet? Posting a sample will likely help, if not by me certainly by others.

EDIT: sorry, your reply was added while i was typing.

This forum is truly amazing ! Time and again it has proven of high value. Its matter of minutes and you get response from people around the globe. Thank you .......