Previous Topic Next Topic

#value

Closed
boule11 Posts 1 Registration date Monday February 10, 2014 Status Member Last seen February 10, 2014 - Feb 10, 2014 at 05:03 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 11, 2014 at 11:49 AM
Hi, am trying to correct a formula. Each time am using this formula:

=IFERROR(VLOOKUP(B15;'Liste des Prix Net'!$A$1:$B$8;2;0);(P15/Q15)*(L15/1000)

there is #value which appear if there is no result.

Can someone help? I need the cell empty if there is no calculation.

2 responses

Answer 1 / 2
2011N2 Posts 13352 Registration date Saturday January 29, 2011 Status Security contributor Last seen December 24, 2016 39
Feb 10, 2014 at 06:33 AM
Hello,

Look at this : https://www.extendoffice.com/documents/excel/664-excel-display-hide-zeros.html

Gabriel.
0
boule11
Feb 10, 2014 at 07:29 AM
Hi, thanks a lot for your reply. Unfortunately that's not the solution. It fact i want to remove the #value when there is no calculation done.
0
Ambucias Posts 47356 Registration date Monday February 1, 2010 Status Moderator Last seen February 15, 2023 11,167
Feb 10, 2014 at 07:51 AM
Click in the cell with #value and delete or correct your formula error
0
Answer 2 / 2
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 11, 2014 at 11:49 AM
Hi Boule11,

I always use the combo IF and ISERROR to remove error messages:

=IF(ISERROR(your formula),"",you formula)
0