help needed urgently

W

wardah

hi, could you please tell me how to replace #N/A error sign with a warning
message that says," the value you have entered is not available" ?
 
M

Max

Try using an IF(ISNA(...) construct:
=IF(ISNA(yourformula),"the value you have entered is not
available",yourformula)
 
S

Stefi

=IF(ISERROR(your formula giving N/A),"the value you have entered is not
available",your formula giving N/A)

Regards,
Stefi

„wardah†ezt írta:
 
Top