Try using an IF(ISNA(...) construct:
=IF(ISNA(yourformula),"the value you have entered is not
available",yourformula)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wardah" wrote:
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" ?