can i specify a value if #N/A is a formula result

[volkl77]

Is there a way using the if formula that I can have a formula return a value such as 0 or - if the result of the formula is #NA? I am creating a sheet that summarizes the hours worked by each employee in a 2 week period, but if that employee is on holidays or has quit i am getting a #N/A result.

 

[Aladin Akyurek]

Is there a way using the if formula that I can have a formula return a value such as 0 or - if the result of the formula is #NA? I am creating a sheet that summarizes the hours worked by each employee in a 2 week period, but if that employee is on holidays or has quit i am getting a #N/A result.

What is the formula leading to #N/A and what is your Excel version?

 

[volkl77]

=IF($D4="Salary","SAL",VLOOKUP($A4,'PP 25'!$A:$I,7,FALSE))

excel 2007

 

[Aladin Akyurek]

=IF($D4="Salary","SAL",VLOOKUP($A4,'PP 25'!$A:$I,7,FALSE))

excel 2007

Try...

=IFERROR(IF($D4="Salary","SAL",VLOOKUP($A4,'PP 25'!$A:$I,7,0)),"-")

 

[T. Valko]

=IF($D4="Salary","SAL",VLOOKUP($A4,'PP 25'!$A:$I,7,FALSE))

excel 2007

Try this...

=IF($D4="Salary","SAL",IFERROR(VLOOKUP($A4,'PP 25'!$A:$I,7,0),"-"))