#n/a errors

[niyrho]

I am using a combination of validation, vlookup and simple formulas to lay out a workorder. If I leave something blank in one of the feilds then everything that comes after say #n/a and won't allow the calculation to complete. Is there a way I can set a default value or something so to make calculate all the feilds that ARE filled in?

 

[Banker1]

The ISNA formula may be more effective set this way:

=IF(ISNA(VLOOKUP(F18,Employees!A1:M14,13,FALSE)),0,VLOOKUP(F18,Employees!A1:M14,13,FALSE)*24*K18)

This will always set a VLOOKUP which returns #N/A to 0 then multiply by 24 and K18 whereas the original ISNA code I presented set the whole string formula to 0.

Apologies.

 

[niyrho]

THanks guys. It's working perfect now.