Do not display #VALUE
cachou52fr
-
romain3169 Posted messages 1738 Registration date Status Membre Last intervention -
romain3169 Posted messages 1738 Registration date Status Membre Last intervention -
Hello,
Configuration: Windows 7 / Internet Explorer 9.0
How not to display #VALUE in an Excel cell that already has the formula "=SUM(D30+7)"
In cell D30, I write today’s date and E30 displays the date 7 days later. However, before I enter my date in D30, E30 shows #VALUE.
How can I avoid this issue?
Thank you for your help if you understand my rambling.
Configuration: Windows 7 / Internet Explorer 9.0
How not to display #VALUE in an Excel cell that already has the formula "=SUM(D30+7)"
In cell D30, I write today’s date and E30 displays the date 7 days later. However, before I enter my date in D30, E30 shows #VALUE.
How can I avoid this issue?
Thank you for your help if you understand my rambling.
2 réponses
Hello,
Find in the Excel help:
To display a dash, #N/A or NA instead of an error value
Use the IF, ISERROR and NA functions to perform this task.
Select the cell containing the error value.
Place the formula that was in the cell inside the following formula, where old_formula represents the formula that was previously in the cell.
=IF(ISERROR(old_formula),"",old_formula)
Examples given in the help:
=IF(ISERROR(A2/A3),"NA",A2/A3) Returns NA when the value is an error
=IF(ISERROR(A2/A3),"-",A2/A3) Returns a dash when the value is an error
=IF(ISERROR(A2/A3),NA(),A2-A3) Returns #N/A when the value is an error
Find in the Excel help:
To display a dash, #N/A or NA instead of an error value
Use the IF, ISERROR and NA functions to perform this task.
Select the cell containing the error value.
Place the formula that was in the cell inside the following formula, where old_formula represents the formula that was previously in the cell.
=IF(ISERROR(old_formula),"",old_formula)
Examples given in the help:
=IF(ISERROR(A2/A3),"NA",A2/A3) Returns NA when the value is an error
=IF(ISERROR(A2/A3),"-",A2/A3) Returns a dash when the value is an error
=IF(ISERROR(A2/A3),NA(),A2-A3) Returns #N/A when the value is an error
