ExcelBanter - help needed urgently

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - help needed urgently (https://www.excelbanter.com/excel-worksheet-functions/112774-help-needed-urgently.html)

wardah

help needed urgently

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" ?

Max

help needed urgently

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" ?

Stefi

help needed urgently

=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:

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" ?

All times are GMT +1. The time now is 03:43 AM.